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

255 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
unbolt8301389(None) 
unbelt83015691unbelt
unbolts9247801unbolts
bolt66254172__bolt
gunboat1047362gunboat
sunbelt939232sunbelt
unbale83616402unbale
unbelts9237662unbelts
unbent83216592unbent
unbolted1179322unbolted
unborn83310812unborn
unbox1438752unbo_x
unbuilt948002unbuilt
unfelt92413462unfelt
unfold10179702unfold
ungot61718062ungo_t
unholy1238162unholy
unmold9148312unmold
unroll61210072unroll
unroot6315552unroot
unsold71410512unsold
untold7149682untold
abbot9318453abbo_t
abort76133583_abort
about75229083_about
abvolt11169833abvolt
anole55330383an_ole
belt65754033__belt
blot65842323__blot
boat66360313__boat
bola66035563__bola
bold75432813__bold
bole66448693__bole
boll65634753__boll
bolo65535953__bolo
bolts76232113__bolts
boot67759373__boot
bort65960963__bort
bot59680403__bo_t
bott66548573__bott
bout66353293__bout
bumboat1349023bumboat
burbot10815653burbo_t
cibol9512023cibol_
cibols1039523cibols
cobalt10317393cobalt
colt67158243__colt
dolt56649423__dolt
emboli1037483emboli
emboly1336723emboly
enfold10137613enfold
enol45823823en_ol_
enols54718403en_ols
enrol51014283enrol_
enroll61110073enroll
enrols61213383enrols
enroot6615993enroot
eyebolt1246363eyebolt
gumboot1246493gumboot
gunboats1144823gunboats
holt77852583__holt
inborn8319143inborn
inbuilt947323inbuilt
incult82414773incult
indol63714873indol_
indole74516053indole
indols74714203indols
indult73614033indult
infold10128163infold
ingot61221063ingo_t
inkblot1344203inkblot
inmost8411363inmost
insole63515863insole
insult62813673insult
intort6418923intort
jabot14321513jabo_t
jolt116639123__jolt
kingbolt1544183kingbolt
knelt94617683kn_elt
knoll9389603kn_oll
knot85630503kn_o_t
knout95018263kn_out
kobold1365963kobold
molt66356163__molt
noble74420993_noble
nobly105314403_nobly
nolo46229313_n_olo
not39474663_n_o_t
nowt78833753_n_owt
nubble103813713nubble
nubbly13369673nubbly
nubile83212713nubile
obol65220613_obol_
obole75917143_obole
oboli73712873_oboli
obols73715863_obols
reboot84119333reboot
revolt9316223revolt
ringbolt1145073ringbolt
robot7325973robo_t
rubout8313563rubout
runabout1045853runabout
runout6414873run_out
sabot7931783sabo_t
smolt74824163_smolt
snool55118643snool_
snools65715883snools
snoot55030143sn_oot
snort54833753sn_ort
snot44745453sn_o_t
snout54530633sn_out
sublot82315523sublot
sunbelts1044673sunbelts
sunbow1145823sunbo_w
sunbows1236023sunbows
tugboat10126103tugboat
turbot8914263turbo_t
umbel93612843umbel_
umbels104510593umbels
umbo85516663umbo__
umbos94613073umbo_s
unable83819223unable
unadult856643unadult
unapt710421593un_apt
unbaled103315963unbaled
unbales92914863unbales
unban72114333unb_an
unbans81912623unbans
unbar71913613unb_ar
unbars82113033unbars
unbe65319273unb__e
unbear889163unbear
unbelted1179333unbelted
unbend9269773unbend
unbid83214643unb_id
unbind93011433unbind
unblest9411813unblest
unblock1545793unblock
unboiled112410373unboiled
unbolting1236453unbolting
unboned103014223unboned
unbonnet1047173unbonnet
unbooted1188773unbooted
unbosom1144483unbosom
unbottle1044223unbottle
unbought1443773unbought
unbound10158393unbound
unbowed132610243unbowed
unboxed17249573unboxed
unboxes16208303unboxes
unbred92613303unbred
unbroke13217743unbroke
unbuild1035723unbuild
unbulky1642853unbulky
unburnt977413unburnt
unbusy1135213unbusy
uncast84215713uncast
uncle7317053un_cle
unclog956603unclog
unco66021403unco__
uncock1438563uncock
uncoil8811853uncoil
uncoils979533uncoils
uncool8610113uncool
uncork1239043uncork
uncos74117033unco_s
uncouth1247173uncouth
uncoy104111413unco_y
uncut73219173un_cut
undo55620153undo__
undock1337703undock
undoer73113043undoer
undoes73917403undoes
undone7914253undone
unduly1037823unduly
unfit84518563un_fit
unfixt16398423unfixt
unfolds11146803unfolds
unfond10149113unfond
ungirt71112713ungirt
ungodly1244473ungodly
ungula737603ungula
unhat81119263un_hat
unhelm1136863unhelm
unhood1039233unhood
unhook1347523unhook
unhurt9311253unhurt
unibody1343353unibody
union54519793unio_n
unions64216753unions
unit45140073un__it
unjoint1449233unjoint
unjust1337873unjust
unkent103116053unkent
unkept123710873unkept
unknit1068593unknit
unknot1037413unknot
unlet54133333un_let
unlit55025463un_lit
unload73010803unload
unlock1248533unlock
unmeet83815743unmeet
unmet74426393un_met
unmixt15378703unmixt
unmolds10135743unmolds
unmolten1044933unmolten
unmoor836313unmoor
unmown11296093unmown
unpent83117373unpent
unpile81914323unpile
unpolite1049173unpolite
unrent63219783unrent
unrest62918853unrest
unrobe82611673unrobe
unrolls797793unrolls
unroof9410193unroof
unroots738563unroots
unrove92511683unrove
unruly938083unruly
unseat64221023unseat
unsell63512543unsell
unsent63820963unsent
unset54532433un_set
unshut939013unshut
unsolid8138373unsolid
unsown9328433unsown
unspilt938853unspilt
unsplit956563unsplit
unspoilt1044883unspoilt
until53517743until_
unto45824283unto__
untorn63012343untorn
unvext1658173unvext
unwell9349443unwell
unwept11389813unwept
unwet84423173un_wet
unwit84417523un_wit
unwon84512343unwo_n
unworn93411333unworn
unwove12238883unwove
unyoke1367293unyoke
upbeat10911513upbeat
upboil1096453upboil
upboils1184703upboils
upbore10247883upbore
upbow1245613upbo_w
upbows1384683upbows
upbuilt1144043upbuilt
upfold12124953upfold
uphold12126903uphold
upmost1068193upmost
uproot8314123uproot
uptilt8410803uptilt
utmost878483utmost
volt76439533__volt

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162555.12621989.1
3Display Results2552550.0763355.3
 (SQL Overall)1786912555.57532052.2
 
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.