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

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

108 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
furred10451443(None) 
burred95820721burred
curred94319261curred
furled104717051furled
purred94218071purred
barred95725792barred
birred94713202birred
blurred10427802blurred
buried94822372buried
burked135220882burked
burled94825382burled
burned95818962burned
burped116215502burped
burrer83718472burrer
churred13409172churred
curbed114615872curbed
curded104217162curded
cured85932132cu_red
curled95021652curled
curried103313652curried
cursed94321252cursed
curved124815222curved
dured75025402du_red
durned84113172durned
erred65915672_erred
faired105915772faired
farced125216532farced
farded114518952farded
fared95842342f_ared
farmed125117652farmed
farted105121782farted
feared106320432feared
ferrel92810202ferrel
ferret93021172ferret
ferried113411522ferried
fired94829742f_ired
firmed125411882firmed
flared105317602flared
flurried12235282flurried
forced126316522forced
forded115020392forded
forged115519322forged
forked145217142forked
formed125021172formed
freed95223542f_reed
fried95322912f_ried
fubbed144711242fubbed
fucked164114482fucked
fudged125212812fudged
fueled104913602fueled
fugged124615382fugged
fugled114813692fugled
fugued11478712fugued
fuhrer1235032fuhrer
fulled103820652fulled
fumed116118822fu_med
funded114413892funded
funked144214112funked
funned103613952funned
furies95126372furies
furler93616402furler
furore9410012furore_
furores10310032furores
furrier103513662furrier
furrow12427742furrow
furrowed1563832furrowed
furry116719282furr_y
furze176815812furze_
furzes186613692furzes
fused94820442fu_sed
fussed104613802fussed
futzed19418982futzed
fuzed185415252fu_zed
fuzzed18479252fuzzed
garred85217402garred
gurged95513362gurged
hurled104617452hurled
hurried113511042hurried
jarred144613252jarred
juried144212442juried
lured65427492lu_red
lurked114511972lurked
marred95421042marred
mured85726702mu_red
murre74821072murre_
murres85019042murres
murrey114312262murrey
nurled74016232nurled
nursed74514662nursed
parred95024072parred
pureed95017802pureed
purged104918262purged
purled94520742purled
pursed95220882pursed
quired163711952quired
slurred8359192slurred
spurred103610622spurred
surfed103814462surfed
surged84118882surged
surrey94414582surrey
tarred74720282tarred
turfed103110962turfed
turned73914472turned
turret63121852turret
urged75316032_urged
urped84615282_urped
warred104019842warred
yirred10426962yirred

Search took 6 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 Filter178691825510.1101624463.6
2DLD Change Limit825511085.12316113.8
3Display Results1081080.0462347.8
 (SQL Overall)1786911085.27933849.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.