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

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
unspilt93885(None) 
unsplit956561unsplit
unspoilt1044881unspoilt
spilt75532222__spilt
unbuilt948002unbuilt
unpile81914322un_pile
unshift1387422unshift
unspent92610892unspent
ensile62616473ens_ile
inbuilt947323inbuilt
insist6314513ins_ist
inspect1138463inspect
inspire938253inspire
inspirit1046283inspirit
instil61111383instil_
instill789063instill
instils7811453instils
insult62813673ins_ult
outspelt10148403outspelt
respelt9312143respelt
resplit9310373resplit
silt46558193__s_ilt
spelt75430193__spelt
spile75230083__spile
spill74821163__spill
spilth11469733__spilth
spirt75032953__spirt
spit65545083__spi_t
split75729013__split
spoilt85016593__spoilt
stilt54831983__stilt
sunspot947163sunsp_ot
sunsuit748693sunsui_t
turnspit1043993turnspi_t
unadult856643unadult
unagile838283unagile
unapt710421593unap__t
unaptly1244793unaptly
unbelt83015693un_belt
unbolt83013893un_bolt
unbuild1035723unbuild
uncoil8811853uncoil_
uncoils979533uncoils
unfelt92413463un_felt
unfit84518563un_fi_t
unfixt16398423un_fixt
ungirt71112713un_girt
unit45140073un__i_t
unjoint1449233unjoint
unknit1068593unkni_t
unlit55025463un_li_t
unmixt15378703un_mixt
unnail6410583unnail_
unnails738223unnails
unpent83117373un_pent
unpick1446903un_pick
unpiled102312743un_piled
unpiles92112783un_piles
unpin72613243un_pi_n
unpins82312383un_pins
unquiet16310663unquiet
unsaid7411833unsai_d
unseal63315473unseal_
unseals73212573unseals
unseat64221023uns_eat
unsell63512543uns_ell
unsells73210773unsells
unsent63820963uns_ent
unset54532433uns__et
unshell1047113unshell
unshifts1444033unshifts
unship1148033unshi_p
unships1237203unships
unshut939013uns_hut
unsight1137483unsight
unsilent849603uns_ilent
unslick1356023unslick
unsling8313643unsling
unsmart939603unsmart
unsoiled92412083unsoiled
unsold71410513uns_old
unsolid8138373unsolid
unspeak1344793unspeak
unspilled1245093unspilled
unspoiled12255563unspoiled
unspoke1336573unspoke
unspool945163unspool
unspools1043693unspools
unspun865793unsp_un
unstick1338123unstick
unswept1246013unswept
until53517743un_til_
untwist1047713untwist
unveil957343unveil_
unveils1045753unveils
unwit84417523un_wi_t
upbuilt1144043upbuilt
uplit76020803u__plit
uppile10178503u_ppile
upshift1545113upshift
uptilt8410803u_ptilt
utopist938693utopist
waspily1535513waspily
wispily1535653wispily

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.423422437.4
2DLD Change Limit1340271047.11018850.5
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.56323627.0
 
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.