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

158 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
unspent9261089(None) 
unpent83117371un_pent
unsent63820961uns_ent
inspect1138462inspect
outspent101310212outspent
spent75532832__spent
unbent83216592un_bent
unguent839122unguent
unkent103116052un_kent
unopen838912unopen_
unpen72913572un_pen_
unpens82511012un_pens
unrent63219782un_rent
unseat64221022uns_eat
unseen62012622unseen_
unset54532432uns_e_t
unsilent849602unsilent
unspeak1344792unspeak
unspilt938852unspilt
unsplit956562unsplit
unspun865792unspun_
unswept1246012unswept
upsent83314062ups_ent
absent84016993abs_ent
anapest9311553anapest
ancient9514733ancient
anent54931843an__ent
arpent84822093_arpent
ascent84519653_ascent
aspect10612823_aspect
aspen75216093_aspen_
aspens85013353_aspens
assent65119953_assent
besprent1248033besprent
consent93723113cons_ent
descent102616293descent
dispend11289413dispend
dissent84018683dissent
distent84120853distent
forspent1348163forspent
incent83320723in_cent
indent73021243in_dent
insect83916583ins_ect
insert64325253ins_ert
inset54430863ins_e_t
insolent81311553insolent
inspan837513inspan_
inspans937803inspans
inspects1255863inspects
instant7815343instant
inswept1245733inswept
intent63122773in_tent
invent93316363in_vent
mispen10312173mispen_
mispens11311073mispens
missent94318713missent
misspent1259173misspent
muniment1248943muniment
nascent9610523nascent
nocent83217413_nocent
onset54730173ons_e_t
outspelt10148403outspelt
outspend11126203outspend
pent66559073___pent
perpent112318813perpent
pungent10311233pun_gent
repent84728873_repent
resent63833623res_ent
respect11412033respect
respelt9312143respelt
scent75831623__scent
sent46963013__s_ent
serpent92916283serpent
shent85933503__shent
spelt75430193__spelt
spend85619333__spend
splent84720193__splent
sprent84522383__sprent
stent55634513__stent
sunset63723633suns_e_t
sunspot947163sunsp_ot
suspect1158513suspect
suspend1036013suspend
unadept1046603unadept
unapt710421593unap__t
unbelt83015693un_belt
unbend9269773un_bend
unblest9411813unblest
unburnt977413unburnt
uncleft1257493uncleft
undrest8313013undrest
uneven957913uneven_
unexpert1744343unexpert
unfelt92413463un_felt
unguenta943713unguenta
unguents945153unguents
unipotent1145503unipotent
unjoint1449233unjoint
unkend11309223un_kend
unkept123710873un_kept
unlet54133333un_le_t
unmeant9510903unmeant
unmeet83815743un_meet
unmet74426393un_me_t
unopened1137023unopened
unpeg8309363un_pe_g
unpegs9256233un_pegs
unpin72613243un_pin_
unpins82312383un_pins
unrest62918853un_rest
unripest1046083unripest
unsawn9317463unsawn_
unscented1237513unscented
unseal63315473uns_eal
unseam83313143uns_eam
unseats73012853uns_eats
unseeing988293unseeing
unsell63512543uns_ell
unsets64116163uns_ets
unsew83912693uns_e_w
unsewn9298393uns_ewn
unsews9379363uns_ews
unsex123512633uns_e_x
unsexy16296903uns_exy
unshapen13155443unshapen_
unshed10313773unshe_d
unshell1047113unshell
unshift1387413unshift
unshut939013uns_hut
unsight1137483unsight
unsling8313643unsling
unslung844563unslung
unsmart939603unsmart
unsound8158433unsound
unsown9328433unsown_
unspeaks1443593unspeaks
unsphere1355853unsphere
unspoilt1044883unspoilt
unspoke1336573unspoke
unspoken1454243unspoken_
unspool945163unspool
unsprung1143173unsprung
unsteel738793unsteel
unstep839223unste_p
unsteps936213unsteps
unstung834853unstung
unsung736983uns_ung
unsunk1036333uns_unk
unswear1035003unswear
unvext1658173un_vext
unwept11389813un_wept
unwet84423173un_we_t
upend85011043u__pend
upsend9356883ups_end
upset73222593ups_e_t
upswept1443473upswept
urgent73816043u_rgent
wisent93516343wis_ent

Search took 7 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 Limit1340271585.92022639.7
3Display Results1581580.0503160.0
 (SQL Overall)1786911586.37628025.6
 
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.