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 “dragline” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

141 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
dragline103684(None) 
draglines1145991draglines
deadline10139052deadline
dragging12308102dragging
draggling1354612draggling
drawling13318672drawling
grapline1138722grapline
praline93019742pra_line
ralline73518412_ralline
ratline74517802_ratline
tagline82412452_tagline
tramline10311382tramline
trapline10411862trapline
acauline1046903acauline
aline57243153__a_line
argling92812733ar_gling
baglike14338943_baglike
bragging13359333bragging
brailing113514793brailing
brawlie12198153brawli_e
brawling143210043brawling
breadline1246273breadline
carline93923613_carline
cauline92215603_cauline
coralline1147943coralline
craaling112711353craaling
crablike1636023crablike
cradling122411453cradling
crawling143110513crawling
daggling12237063daggling
dangling112611233dangling
darkling1437483darkling
darling93418363d_arling
dartling1039563dartling
dateline9810353dateline
deadlined12125323deadlined
deadlines11138503deadlines
dealing94323233dea_ling
decline103716613d_ecline
derailing112011313derailing
dialing94318173dia_ling
dialling10310783dialling
diamine10311983dia_mine
diazine1738933dia_zine
doglike13207453d_oglike
drabbing14286803drabbing
drabbling1544553drabbling
drafting13339403drafting
dragee84415603drag__ee
draggier11135773draggier
draggle1056103drag_gle
dragnet91211433drag__net
dragomen1245013dragomen
dragon838843drag_on_
dragonet10138953drag_onet
dragons938383drag_ons
dragoon935283dragoon_
dragooned1242963dragooned
dragoons1045013dragoons
dragrope1243203dragrope
drain65222893dra__in_
drained93713253dra__ined
drainer83012843dra__iner
draining103312673draining
drains73719403dra__ins
dramming14347563dramming
draping114213353dra_ping
dratting10389653dratting
drawing123812053dra_wing
drawlier12225253drawlier
draying123813843dra_ying
dreamlike1642753dreamlike
drilling103311983drilling
driveline1345353driveline
drolling103510763drolling
drooling102610423drooling
druggie10134073druggi_e
drugging12326443drugging
drumlike1543793drumlike
drumlin1044423drumlin_
drumlins1144993drumlins
dualize1759763dua_lize
eagling91113603_eagling
flatline11298923flatline
fragging14329423fragging
fragile1147843frag_ile
froglike1634363froglike
gargling11239203gargling
gradine93317033gra_dine
graplin1058443graplin_
graplines1237353graplines
graplins1148263graplins
gratine84719193gra_tine
grayling1338003grayling
hardline12310273hardline
headline12129613headline
hyaline132310723hya_line
imagine1037883imag_ine
jawline17137063_jawline
kaoline11310143_kaoline
kraaling13186663kraaling
longline938763longline
maline84529083_ma_line
marline93320953_marline
opaline9412483opa_line
paraglide1345703paraglide
pargyline1544653pargyline
pralines102217723pra_lines
proline92321593pr_oline
ragging103516683_ragging
raging85126433_rag_ing
raglan73711503_raglan_
raglans82410133_raglans
ragtime1036163_ragtime
railing83325643_railing
rapine85023083_ra_pine
ratine65131823_ra_tine
ratlike113912353_ratlike
ratlin64116523_ratlin_
ratlines83815293_ratlines
ratlins73615583_ratlins
ravine95522223_ra_vine
raylike14269253_raylike
recline94020493_recline
redline84218833_redline
reguline939503_reguline
reline65434353_r_eline
ruglike1236283_ruglike
saline65132703_sa_line
snaglike1335283snaglike
taglike12278913_taglike
taglines92210833_taglines
trailing92916093trailing
tramlines1139843tramlines
traplike1437653traplike
traplines11310373traplines
trawling122710783trawling
trotline8310023trotline
uralite71714103ura_lite
valine94623093_va_line
wrangling1456223wrangling

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621416.65621959.4
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.10825139.4
 
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.