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

163 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
unsober96764(None) 
enrober9218622enrober
sober74822412__sober
uncover1239002uncover
undoer73113042undo_er
unlobed10219742unlobed
unrobe82611672unrobe_
unrobed102711212unrobed
unrobes9269732unrobes
unsoberly1443032unsoberly
unsolder937212unsolder
unsowed112511052unsowed
absorber1254313absorber
adsorber1143503adsorber
annoyer1095603annoyer
answer936893ans_wer
consoler102812613consoler
disobey1346243disobey
disrober1147623disrober
encoder1038633encoder
endower1138483endower
enjoyer1744383enjoyer
ennobler1043543ennobler
enrobe86610793enrobe_
enrobed10279253enrobed
enrobers10236953enrobers
enrobes92211113enrobes
ensurer73011903ensurer
goober93911743_goober
hungover15133123hungover
incomer1169943incomer
insaner7310443insaner
insider849733insider
insofar1043543insofar
insole63515863insole_
insoles73516243insoles
insurer73312803insurer
intoner7811673intoner
invoker1435363invoker
isobar836143_isobar
isomer8310153_isomer
knower1337083kn_ower
munster93710523muns_ter
nabber104913543_nabber
nobler83713453_n_obler
nooser65517823_nooser
nosher94616363_nosher
nosier63716323_nosier
noter55025643_n_oter
number103913223_number
prober104516073_prober
punster92911103puns_ter
ransomer1047883ransomer
runover1034663run_over
saber75330243__saber
snooker113910303snooker
snooper93511533snooper
snoozer16409193snoozer
snorer64316763sn_orer
snubber11277733snubber
sobber104016593__sobber
sobers85218863__sobers
somber103714003__somber
sorer56236593__sorer
sower85229313__sower
suber74924503__suber
ugsome934783ugsome_
ulster63712103uls_ter
umber94617593u__mber
unbar71913613un__bar
unbe65319273un__be_
unbear889163un__bear
unbobbed1234413unbobbed
unboned103014223unboned
unbosomer1362973unbosomer
unbowed132610243unbowed
unboxed17249573unboxed
unboxes16208303unboxes
uncoded11312743uncoded
uncombed1536323uncombed
uncovers1336573uncovers
under64624213un__der
undoers82910583undo_ers
undoes73917403undo_es
undone7914253undone_
uneager839753uneager
unfolder12216583unfolder
unholier1137283unholier
unhoped13249353unhoped
unifier102211863unifier
unilobed1136393unilobed
uniquer1675783uniquer
uniter64619143un_iter
unkosher1573763unkosher
unlimber1243373unlimber
unloader936643unloader
unloved112310533unloved
unmaker13279513unmaker
unmiter9310393unmiter
unmoor836313unmo_or
unmoved13248903unmoved
unnoted8311363unnoted
unopen838913un_open
unposed10711903unposed
unprobed1366973unprobed
unriper9188283unriper
unroped102812103unroped
unrove92511683unrove_
unroven10238143unroven
unsafe9310693unsafe_
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unscrew1245463unscrew
unseen62012623uns_een
unset54532433uns__et
unsew83912693uns__ew
unsewed112911023unsewed
unsex123512633uns__ex
unsexed152410253unsexed
unsexes14248923unsexes
unshed10313773uns_hed
unsicker1435303unsicker
unsized172510543unsized
unsmoked1536013unsmoked
unsoaked1338853unsoaked
unsoiled92412083unsoiled
unsold71410513unso_ld
unsolders1064693unsolders
unsolid8138373unsolid
unsolved1237833unsolved
unsoncy1245513unsoncy
unsonsy1045023unsonsy
unsorted9312513unsorted
unsound8158433unsound
unsounder1044373unsounder
unsoured9310063unsoured
unsown9328433unso_wn
unsphere1355853unsphere
unspoke1336573unspoke_
unspoken1454243unspoken
unstabler1145623unstabler
unsteel738793unsteel
unstep839223uns_tep
unstoned9311043unstoned
unstopper1343523unstopper
unsure62815413unsure_
unswear1035003unswear
unswore1039053unswore_
untruer737113untruer
unwiser1037123unwiser
unwooed11229773unwooed
unwove12238883unwove_
unwoven13176673unwoven
unyoke1367293unyoke_
unyoked1567123unyoked
unyokes1466733unyokes
unzoned172310653unzoned
upsoar8105683upso_ar
user45023003u_s__er
usher84517763u_s_her
usurer638103u_surer
winsomer1345773winsomer

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 Limit1340271635.96622465.1
3Display Results1631630.0463543.5
 (SQL Overall)1786911636.41827842.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.