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 “fanwort” 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.

117 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
fanwort1331073(None) 
fanworts1446101fanworts
danewort1258242danewort
felwort13410582felwort
figwort1448222figwort
madwort13611362madwort
ragwort11510742ragwort
sandwort12410082sandwort
abort76133583_a_bort
amort75832203_a_mort
angora71111573_angora
aport75432173_a_port
assort64916383_assort
awlwort1356353awlwort
bagworm1566353bagworm
bandora1038813bandora
bandore10611633bandore
candor94516423candor_
candors104216763candors
cannot83616773canno_t
cantor85621523cantor_
cantors94620753cantors
carport11316033carport
cavort11316173ca_vort
consort91319903consort
contort91422343contort
damewort1447443damewort
daneworts1344873daneworts
daywork1845653daywork
earworm1238743earworm
factor11911463factor_
factors12912133factors
factory15108353factory
fadeout11410193fadeout
faggot1139053faggo_t
fagot9323403fa_go_t
fallout10313503fallout
fancywork2451953fancywork
fandom122110893fando_m
fandoms13229473fandoms
fanfare1336673fanfare
fanfold1485373fanfold
fanion94514323fanio_n
fanions103713073fanions
fanjet16311393fan_jet
fanner94218183fanner_
fanners103914653fanners
fano75831693fan_o__
fanon84619013fan_o_n
fanons96115213fan_ons
fanos85926503fan_o_s
fantast10311703fantast
fantod102010033fanto_d
fantods11177623fantods
fantom112110803fanto_m
fantoms12189153fantoms
fanwise1336633fanwise
farmwork2044193farmwork
fart76860563fa___rt
fatwood1486393fatwood
favor114712453fa_vor_
favors124211403fa_vors
fawner125910463fawner_
fawners13388493fawners
felworts1445953felworts
figworts1544683figworts
finfoot1347173finfoot
flatwork1845393flatwork
flatworm1645183flatworm
fleawort1447023fleawort
fort76456443f___ort
forworn13107793forworn
frankfort1952673frankfort
handout11314103handout
handwork1946903handwork
hangout11411393hangout
honewort14410083honewort
hornwort1447793hornwort
intort6418923_intort
leadwort1247473leadwort
loanword1244413loanword
lungwort1245493lungwort
madworts1456173madworts
manor78023933man_or_
manors84420883man_ors
manward1349093manward
moonwort1367813moonwort
mugwort1346753mugwort
nonword1149153nonword
nonwork1448423nonwork
pandora1039543pandora
pandore10411853pandore
pawnor11357243pawnor_
pawnors12297203pawnors
pinwork16107243pinwork
pinworm1467183pinworm
ragworts12125803ragworts
rancor8810373rancor_
rancors9811373rancors
rapport11311223rapport
ribwort1249003ribwort
saltwort1148603saltwort
sandworm1446343sandworm
sandworts1346453sandworts
snort54833753_sn_ort
soapwort1347553soapwort
spanworm1544203spanworm
starwort1198683starwort
tinwork1476993tinwork
unworn93411333_unworn
vanward1456943vanward
warwork1757583warwork
warworn1357353warworn
waxwork24104883waxwork
waxworm2264573waxworm
wayworn1675293wayworn
wort76654753___wort

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271175.90622693.4
3Display Results1171170.0502340.0
 (SQL Overall)1786911176.35928100.5
 
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.