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

178 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
unbolts924780(None) 
unbelts9237661unbelts
unbolt83013891unbolt_
bolts76232112__bolts
gunboats1144822gunboats
sunbelts1044672sunbelts
unbales92914862unbales
unbelt83015692unbelt_
unbolted1179322unbolted
unboxes16208302unboxes
unfolds11146802unfolds
unmolds10135742unmolds
unrolls797792unrolls
unroots738562unroots
abbots1039283abbo_ts
aborts84916183_aborts
abvolts12104373abvolts
anoles64827423an_oles
belts75931163__belts
blots75626173__blots
boats75635153__boats
bolas74733763__bolas
bolds85825283__bolds
boles75448603__boles
bolls75531313__bolls
bolos75531373__bolos
bolt66254173__bolt_
bolus79125543__bolus
boots75837973__boots
borts76735453__borts
bots66453953__bo_ts
botts75224863__botts
bouts75131313__bouts
bumboats1445183bumboats
burbots1168673burbo_ts
cibols1039523cibol_s
cobalts1139203cobalts
colts76633293__colts
dolts65626313__dolts
embolus1135543embolus
enfolds11136253enfolds
enols54718403en_ol_s
enrolls7108093enrolls
enrols61213383enrol_s
enroots738713enroots
eyebolts1343483eyebolts
gumboots1344253gumboots
gunboat1047363gunboat_
holts85627913__holts
indoles83716363indoles
indols74714203indol_s
indults8289493indults
infolds11137023infolds
ingots7912063ingo_ts
inkblots1442663inkblots
insoles73516243insoles
insults7268963insults
intorts7310963intorts
jabots1538883jabo_ts
jolts125018883__jolts
kingbolts1642433kingbolts
knolls10367413kn_olls
knots95614723kn_o_ts
knouts10438313kn_outs
kobolds1474343kobolds
molts76032093__molts
nobles83319723_nobles
nolos54423353_n_olos
nowts86915853_n_owts
nubbles113412433nubbles
oboles83815833_oboles
obols73715863_obol_s
obolus8378813_obolus
reboots93512093reboots
revolts1038893revolts
ringbolts1242803ringbolts
robots8313143robo_ts
rubouts937973rubouts
runabouts1142713runabouts
runouts737343run_outs
sabots8314693sabo_ts
smolts84411883_smolts
snools65715873snool_s
snoots64216663sn_oots
snorts64116493sn_orts
snots55225103sn_o_ts
snouts64915863sn_outs
sublots92410913sublots
sunbelt939233sunbelt_
sunbows1236023sunbo_ws
tugboats11154103tugboats
turbots988023turbo_ts
umbels104510583umbel_s
umbles103817483umb_les
umbones1138013umbones
umbos94613063umbo__s
unbale83616403unbal_e
unbaled103315963unbaled
unbans81912623unb_ans
unbars82113033unb_ars
unbears998043unbears
unbelted1179333unbelted
unbends10236993unbends
unbent83216593unbent_
unbinds10267353unbinds
unblest9411813unb_lest
unblock1545793unblock
unblocks1644523unblocks
unboiled112410373unboiled
unbolting1236453unbolting
unboned103014223unboned
unbonnets1143383unbonnets
unbooted1188773unbooted
unborn83310813unbo_rn
unbosom1144483unbosom
unbosoms1243253unbosoms
unbottle1044223unbottle
unbottles1143463unbottles
unbound10158393unbound
unbowed132610243unbowed
unbox1438753unbo__x
unboxed17249573unboxed
unbuilds1143153unbuilds
unbuilt948003unbuilt_
unbulky1642853unbulky
uncles8317163un_cles
unclogs1036803unclogs
uncocks1537233uncocks
uncoils979533uncoils
uncorks1337443uncorks
uncos74117033unco__s
uncouth1247173uncouth
undocks1436163undocks
undoers82910573undoers
undoes73917403undo_es
unfelt92413463unfelt_
unfits93910293un_fits
unfold10179703unfol_d
ungot61718063ungo_t_
unhats91110623un_hats
unhelms1234223unhelms
unholy1238163unhol_y
unhoods1137503unhoods
unhooks1436413unhooks
unions64216753unio_ns
units54923433un__its
unjoints1544433unjoints
unknits1135553unknits
unknots1144303unknots
unloads8278523unloads
unlocks1337063unlocks
unmold9148313unmol_d
unmolten1044933unmolten
unmoors945903unmoors
unpiles92112783unpiles
unpolite1049173unpolite
unrests7229463unrests
unrobes9269733unrobes
unroll61210073unrol_l
unroofs1035783unroofs
unroot6315553unroot_
unseats73012853unseats
unsells73210773unsells
unsets64116163un_sets
unsold71410513unsol_d
unsolid8138373unsolid
untold7149683untol_d
unwits9389893un_wits
unyokes1466733unyokes
upbeats1195733upbeats
upboils1184703upboils
upbows1384683upbo_ws
upfolds13133753upfolds
upholds13135243upholds
uproots937143uproots
uptilts934733uptilts
utmosts934593utmosts
volts85421293__volts

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.1561145455.1
2DLD Change Limit1340271787.39018136.3
3Display Results1781780.0961854.2
 (SQL Overall)1786911787.64223382.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.