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

101 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
joseph1815216(None) 
josephs19161831josephs
josh145117612jos__h
aleph10311393_aleph
bosh96328973bos__h
cometh134811683cometh
cosec96320183cose_c
cosecs105015213cosecs
coses76949493cose_s
coset75748843cose_t
cosets85824403cosets
cosey106226713cose_y
coseys115215813coseys
cosh96127623cos__h
doeth9411983do_eth
dose56442433dose__
dosed76626913dose_d
doser66228563dose_r
dosers75723633dosers
doses65938503dose_s
gonoph1235403gonoph
gosh86123423gos__h
gospel936533gospel
hose76547243hose__
hosed95830983hose_d
hosel86024813hose_l
hosels94218603hosels
hosen85623883hose_n
hoser811529763hose_r
hosers95223963hosers
hoses85443173hose_s
hosey116127023hose_y
hoseys124614003hoseys
jasper154610383jasper
jeep135624843j_eep_
jeeps144715373j_eeps
joe106642353jo_e__
joes116635893jo_e_s
joey145719333jo_e_y
joeys15518043jo_eys
joke155926163joke__
joked175217913joke_d
joker165715893joke_r
jokers175511193jokers
jokes165423333joke_s
jokey195014693joke_y
jole117233823jole__
joles125230833jole_s
jones125028183jone_s
joshed174610903joshed
josher164312963josher
joshers174111593joshers
joshes165114853joshes
joss115925593jos__s
josses135117683josses
jostle13319863jostle
jowed164724423jowe_d
joyed164811833joye_d
julep14310533julep_
juleps1535623juleps
koph135816543ko__ph
lose45144583lose__
losel54419423lose_l
losels64714583losels
loser54728673lose_r
losers65123583losers
loses56742013lose_s
morph121712513mo_rph
mosey105922873mose_y
moseys114711703moseys
mosh95227603mos__h
nose46739363nose__
nosed65524553nose_d
noses55435643nose_s
nosey85619883nose_y
nosh76223543nos__h
obeah1038993_obeah
okeh114615323_oke_h
oomph1236973_oomph
ose38147343_ose__
oses46641513_ose_s
ouph95618373_o_uph
pose66441733pose__
posed85828413pose_d
poser75128773pose_r
posers84223973posers
poses74642763pose_s
poseur8419403poseur
posh95427323pos__h
qoph185911943qo__ph
rose46148903rose__
rosed65930343rose_d
rosery93813283rosery
roses56445773rose_s
roset55945243rose_t
rosets65819953rosets
sept65844363__sept
soph97024203__soph
syph125413273__syph
toph96326873to__ph
tosh74826813tos__h

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.390458182.1
2DLD Change Limit1127161014.64324276.5
3Display Results1011010.0137769.2
 (SQL Overall)1786911015.04635412.4
 
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.