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

111 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
deflower1512607(None) 
beflower16166271beflower
deflowers16145641deflowers
reflower14126841reflower
beflowers17165822beflowers
bellower13159062bellower
dayflower1942542dayflower
deflater123211602deflater
deflowered1842512deflowered
deflowerer1752072deflowerer
deplorer1136342deplorer
deployer1445632deployer
flower124815502__flower
mellower13167402mellower
reflowed15126902reflowed
reflowers15125982reflowers
yellower14186212yellower
beflowered1942903beflowered
bellflower1852403bellflower
bellowed14158603bellowed
bellowers14177623bellowers
bestower13126213bestower
blower115316573__blower
callower13159073callower
coneflower1873213coneflower
dayflowers2052413dayflowers
dealer74122143deal__er
deboner103110483de_boner
declarer1148063declarer
declawed1545923declawed
decliner113710843decliner
decoder113712293de_coder
decoyer13348683de_coyer
defacer132810363def_acer
defamer132710323def_amer
defeater122611663defeater
defender1337293defender
defer94619753def___er
deferrer12135593deferrer
deffer134411303def__fer
defier105118653def__ier
defiler113911883def_iler
definer114413773def_iner
deflate113613943deflate_
deflated133412303deflated
deflaters13298703deflaters
deflates123013943deflates
deflator12328343deflator
deflea1037443defl__ea
defleaed1344953defleaed
deflexed2043883deflexed
deflowerers1851623deflowerers
deflowering1952653deflowering
defoamer14276213defoamer
defogger1443533defogger
deforcer14246903deforcer
deformer14247943deformer
defrayer1534933defrayer
defroster1343893defroster
defter104215923def__ter
defuser115110503def_user
delayer113010533de_layer
deliver113312243de_liver
delouser936363de_louser
deluder9168333de_luder
delver104913493de_l_ver
depleter11298863depleter
deplore1039483deplore_
deplored1237233deplored
deplorers1245463deplorers
deplores1139533deplores
deployed1535913deployed
deployers1545063deployers
deposer104011843de_poser
developer15134243developer
dialoger1056083dialoger
dower95027703d___ower
eloper85414153_e_loper
embower14267403_embower
empower14217033_empower
endower1138483_endower
fellowed15136833fellowed
flowed133513763__flowed
flowers133413173__flowers
flowery16327783__flowery
follower14137073follower
geologer1044483geologer
glower105114933__glower
hallower14139813hallower
hollower14127393hollower
leftover1442713leftover
lower85830413___lower
mayflower2042723mayflower
mellowed14166923mellowed
plower114315063__plower
reflow12379653reflow__
reflowered1742983reflowered
reflown13316213reflow_n
reflows13258983reflow_s
reglowed13125853reglowed
replowed14127573replowed
repower12329883re_power
reshower14107063reshower
safflower1842993safflower
sallower11139503sallower
slower94016153__slower
sunflower1563553sunflower
upflowed1742893upflowed
wallower14158933wallower
willower14127453willower
yellowed15185743yellowed

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 Limit1461621117.11020557.2
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.56223630.1
 
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.