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

104 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
dunce8631926(None) 
dance85223131dance
duce76933501du_ce
dunces95215751dunces
dunch115316261dunch
dune56137581dun_e
ounce77019931ounce
adunc837432adunc_
bedunce1235682bedunce
bounce104014832bounce
bunch125118602bunch
bunco94616082bunco
dace76934922d_ace
danced105315252danced
dancer94817612dancer
dances95120652dances
deice84320032deice
dene56643412den_e
dense65923502dense
deuce84517492deuce
dice75841892d_ice
dine55555332din_e
dinge75627302dinge
dolce85816682dolce
done55747912don_e
donee66931012donee
donne65520462donne
douce85518422douce
duces86327472du_ces
duci76422622du_ci
duck115929172du_ck
duct75735462du_ct
dude65629662du_de
due45249862du__e
duende836922duende
duke95628102du_ke
dulcet9314492dulcet
dulse65415042dulse
dun46545582dun__
dunam8313732dunam
dunches133312582dunches
dunes65332172dunes
dung66328432dun_g
dunged95414692dunged
dungs75821972dungs
dungy104713642dungy
dunite7315012dunite
dunk96228572dun_k
dunked124315282dunked
dunker113616462dunker
dunks105621192dunks
dunned85015522dunned
dunner73913822dunner
duns55140432dun_s
dunt55746872dun_t
dunted84718502dunted
dunts65828412dunts
dupe76630602du_pe
duple85315862duple
durance1059112durance
dure56341812du_re
dutch114713822dutch
dyne85320932dyn_e
educe84313452edu_ce
fence105319912fence
hance105424152hance
hence104920042hence
hunch136416212hunch
jaunce15367432jaunce
jounce153310732jounce
juice14311322juice
junco144612202junco
kune85424572kun_e
lance75126722lance
launce8469182launce
luce65132572lu_ce
lunch104917242lunch
lune47140492lun_e
lunge65323802lunge
mince95325232mince
munch124917102munch
nance74721842nance
nonce75719822nonce
nuance859042nuance
nuncle839362nuncle
once65423082_once
ounces83617772ounces
pence94924452pence
ponce95222512ponce
pounce105214092pounce
puce85127882pu_ce
punch125118422punch
quince173910132quince
rance75028512rance
rune45236302run_e
since75024172since
tune45635862tun_e
unbe65319272_unbe
unci65019462_unci
uncle7317052_uncle
unco66021402_unco
unde55825482_unde
wince105220882wince
yince105214252yince

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001041.67332157.8
3Display Results1041040.0303466.7
 (SQL Overall)1786911042.01688636.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.