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

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

100 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
freedom134586(None) 
freedoms1445431freedoms
fiefdom1643012fiefdom
freed95223542freed__
freeform1644702freeform
unfreedom1551402unfreedom
boredom1236943boredom
breed85526693breed__
breeder103210043breeder
breeds94914883breed_s
chefdom18134073chefdom
credo84815573cr_edo_
credos94612853cr_edos
creed85727393creed__
creedal1037093creedal
creeds94714773creed_s
dogedom1244663dogedom
dreed75222843dreed__
dukedom1542773dukedom
fandom122110893f_andom
feed84538903f_eed__
feedbox2052663f_eedbox
feeder103513843f_eeder
feedlot11135933f_eedlot
feeds94921143f_eed_s
fiefdoms1742793fiefdoms
filmdom1562943filmdom
firedog1244473firedog
fireroom1346063fireroom
foreboom1546133foreboom
foredo10510823foredo_
foredoom1445813foredoom
fraenum1255703fraenum
free75940183free___
freebee1238043freebee
freebie1236043freebie
freeboot1345933freeboot
freeborn1344803freeborn
freedman1444143freedman
freedmen1444553freedmen
freedwoman1951753freedwoman
freedwomen1952403freedwomen
freehold1554683freehold
freeing113713913freeing
freeload1244733freeload
freely12310963free_ly
freeman1237343freeman
freemen1238463freemen
freer86021243free__r
freers94717303free_rs
frees86131393free__s
freesia1046323freesia
freest95318283free_st
freeway1635603freeway
freeze18349513free_ze
freezer19348523freezer
freezes193310353freezes
fremd115010323fremd__
frenum1188803fr_enum
fresco1136473fresco_
frescos1236813frescos
fretsome1345853fretsome
fried95322913fried__
from96923923fr___om
geekdom1542283geekdom
greed75125693greed__
greeds84314283greed_s
greedsome1352983greedsome
greedy11518853greed_y
popedom1445453popedom
preboom1348253preboom
preed85128123preed__
preedit10512463preedit
queendom2042253queendom
random92513553_random
rebeldom1342473_rebeldom
redeem9311533_redeem
redo56029363_r_edo_
redon65424883_r_edon
redos65126763_r_edos
redox134714233_r_edox
reed55549623_reed__
reeded84022563_reeded
reedit7617223_reedit
reeds65430903_reed_s
reedy910020293_reed_y
reendow11285063_reendow
reredos838633_reredos
seldom939413_seldom
serfdom1344213serfdom
speedo94011993speedo_
speedos10298263speedos
teredo7310783teredo_
teredos839183teredos
treed65626733treed__
treetop945523treetop
unfreedoms1651203unfreedoms
uredo65112993ur_edo_
uredos73910623ur_edos
wifedom1643553wifedom

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271007.43618024.1
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.87222699.6
 
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.