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

169 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
justice163742(None) 
justices1737521justices
auspice1136522auspice
bustic101012692bustic_
bustics11810882bustics
fustic11910632fustic_
fustics1279592fustics
injustice1843772injustice
juice14311322ju__ice
jussive1734292jussive
justify2034662justify
justing153615162justing
justle133211582just_le
rustic8712672rustic_
rustics9810732rustics
adjustive2043243adjustive
auntie64317703aunti_e
auspices1236443auspices
austere7312993austere
bastile9313913bastile
busticate1357753busticate
bustier93916153bustier
busting104221793busting
bustle84015483bust_le
bustline10208843bustline
caustic1139753caustic_
caustics1237483caustics
costive12312843costive
cultic105111903cultic_
cuticle1138233cu_ticle
cutie76925933cu_ti_e
cystic132710653cystic_
cystine1239333cystine
destine83719953destine
distich13312173distich
ductile1048483ductile
dustier83814133dustier
dustily113211533dustily
dusting93618993dusting
dustlike1335363dustlike
entice81316863_entice
eustacy1254663eustacy
eustele738193eustele
festive1339773festive
fistic11812573fistic_
furtive1337173furtive
fusile94313493fus_ile
fustian1036903fustian
fustier104213933fustier
fustily133111383fustily
futile93914953fu_tile
gestic9312773gestic_
gussie72910153gussi_e
gustier83813863gustier
gustily113010903gustily
gusting93917163gusting
hospice14117063hospice
hostile10312553hostile
hustle93113993hust_le
huswife1642223huswife
injustices1953223injustices
jasmine1636643jasmine
jaundice1842013jaundice
jesting154317713jesting
jostle13319863jost_le
jousting16309353jousting
joystick2442883joystick
jubile152910263ju_bile
juiced1636513ju__iced
juicer1536283ju__icer
juices1549423ju__ices
juicy1738283ju__icy
junkie17339603junki_e
juristic1746133juristic_
jussives1833843jussives
just115433343just___
justed144215773just_ed
juster134617013just_er
justers143815733justers
justest1449893justest
justiciar1853313justiciar
justified2045043justified
justifier1944363justifier
justifies1945793justifies
justled15338093justled
justles143311433justles
justling16207253justling
justly16307253just_ly
justs124918263just__s
jute115327893ju_t__e
juttied15417863juttied
jutties143814003jutties
jutting153313713jutting
lattice938433lattice
luetic8310383luetic_
luetics937323luetics
lustier73813503lustier
lustily103611243lustily
lusting83619323lusting
lustre64011683lust_re
mastic103119173mastic_
mastiche1547173mastiche
mastics112614783mastics
mistime11312613mistime
mortice11711493mortice
music94316403mus_ic_
musick14408703mus_ick
musics103911783mus_ics
muskie123412543muski_e
muspike1536043muspike
mustache15185283mustache
mustee83922103must_ee
mustier94017963mustier
mustily123613633mustily
musting103221073musting
mutine84420373mu_tine
mystic132711643mystic_
mystics14279103mystics
nastic82915973nastic_
neustic937943neustic_
notice8313443_notice
ousting84021353ousting
outside82414193outside
outsize162411753outsize
pastiche1546933pastiche
pastie85525523pasti_e
pastime114611973pastime
postiche1547793postiche
postie84123963posti_e
poultice1246063poultice
pumice1238223pu_mice
puslike1347563puslike
pustule937683pustule
puttie84116303putti_e
restive10315933restive
rusine63916593rus_ine
rustical1048393rustical
rusticate1149033rusticate
rusticly1345183rusticly
rustier74416363rustier
rustily103112993rustily
rusting83821263rusting
rustle63615413rust_le
rutile65217683ru_tile
saice75424053__saice
sestine73017923sestine
sice65545603__s_ice
slice74925823__slice
solstice1047223solstice
spice95528813__spice
statice92614033statice
stich104117923__stich
stick115121563__stick
stile54931573__stile
stime76521803__stime
stipe76523373__stipe
subtile91912623subtile
suffice15197573suffice
suspire937803suspire
testicle1037443testicle
tushie939723tushi_e
tussive1035303tussive
unstick1338123unstick
untie54425493_unti_e
uptick1436763_uptick
uptime1067673_uptime
usance858013_usance
utile54718933_u_tile
vestige1137433vestige

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 Limit1340271696.87319500.5
3Display Results1691690.0632682.5
 (SQL Overall)1786911697.34224338.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.