Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “carjackings” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
carjackings275163(None) 
carjacking2643541carjacking_
crackings18346842c_r_ackings
barracking1944713barracking_
caretakings1852903caretakings
carjackers2553403carjack_ers
carjacks2345573carjack___s
catfacings1842183catfac_ings
cracking174013903c_r_acking_
cracklings19143523c_r_acklings
skyjackings275823skyjackings
tarmacking1944233tarmacking_
trackings16247543_tr_ackings
arcadings1354394_arca_dings
archings14499864_ar__chings
arcking145811964_ar__cking_
attacking1635324_attacking_
backings174012214___backings
blackings18316764__blackings
bracings13369294_br_ac_ings
breakings16297064_brea_kings
calkings15289224c___alkings
canakins142010464ca_na_kin_s
carabines13311464car_a_bines
carabins12312354car_a_bin_s
caracks152211564car_ack___s
caracoling1545634car_acoling_
cardings123812634car___dings
caregivings1851414caregivings
caretaking1765334caretaking_
carjack2246154carjack____
carjacked2543354carjack__ed
carjacker2443824carjack__er
carking144322854car___king_
carlings114015854car___lings
carpaccios1552104carpacci_os
carpetings1544214car_petings
carpings133812384car___pings
carracks1637714carrack___s
cartoonings1442664cartoonings
carvings143810204car___vings
catfacing1744554catfac_ing_
catjangs1843224catja___ngs
caulkings1633354ca__ulkings
characins1647594char_ac_in_s
clacking173313494c__lacking_
crackling18157004c_r_ackling_
cranking154613074c_r_anking_
cravings14428224c_r_a_vings
creaking153414124c_rea_king_
cricking173412654c_r_icking_
croaking153712164c_roa_king_
crocking174313444c_r_ocking_
earmarking1743584earmarking_
garlicking1843054garlicking_
hijacking2642764_hijacking_
hopsackings2351104hopsackings
jacking214515264___jacking_
kayakings1642684ka_ya_kings
lawmakings2042374lawma_kings
mapmakings2142454mapma_kings
markings153410244mar___kings
meatpackings2351114meatpackings
packings174310064___packings
parawings1535824par_a_wings
parbaking1877204parba_king_
parkings153610684par___kings
partaking1698674parta_king_
phreakings2043194phrea_kings
prickings18315654_pr_ickings
racings105015134__r_ac_ings
racking144323664__r_acking_
rankings13389174__r_ankings
ransacking1744424ransacking_
reracking1639314rer_acking_
sackings15389634___sackings
skyjacking2641604skyjacking_
streakings15235304strea_kings
surfacings1642454surfac_ings
tracings112910414_tr_ac_ings
tracking153715464_tr_acking_
truckings16235024_tr_uckings
wracking18349964_wr_acking_
wreckings19233684_wr_eckings

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.1561145455.1
2DLD Change Limit148819848.51617475.2
3Display Results84840.0461826.1
 (SQL Overall)178691848.71820496.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.