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 “hobos” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

155 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
hobos10632135(None) 
gobos86219371gobos
hobo97026081hobo_
hoboes114717441hoboes
hobs97038981hob_s
homos105921781homos
kobos115616891kobos
lobos75921841lobos
abos67734412_abos
adobos9438452adobos
ambos95321252ambos
bobs86340652bob_s
bohos105618252bohos
bolos75531372bolos
boobs96221992boobs
boos67955032bo_os
bos57966812__bos
boyos105418282boyos
bozos165216862bozos
cholos114716852cholos
cobbs115013992cobbs
cobs87043142cob_s
cocos95624692cocos
cohos105921852cohos
combos125316612combos
coos67456492co_os
dhobis1236102dhobis
dobros93910232dobros
dodos75819392dodos
dojos135111792dojos
fobs96034272fob_s
gobo76126892gobo_
goboes95914442goboes
gobs76935572gob_s
gogos77516522gogos
gombos114311092gombos
goos57644912go_os
habus106317142habus
halos85230252halos
hebes105521672hebes
helos84928062helos
heros84930862heros
hoars85925542hoars
hob87550922hob__
hobby155913732hobby
hobnob1335132hobnob
hobnobs1443602hobnobs
hoboed124511682hoboed
hoboism1446612hoboism
hocks144925492hocks
hocus104715202hocus
hods87239862ho_ds
hoers85724922hoers
hoes75755732ho_es
hoggs107212462hoggs
hogs87139662ho_gs
hokes126231642hokes
holds94623242holds
holes84748652holes
holks124720562holks
hollos95320632hollos
holms105117802holms
hols76946292ho_ls
holts85627912holts
homes106938812homes
hommos13128502hommos
homo96126472homo_
hones88144492hones
hongs95126202hongs
honks125124522honks
honor85718622honor
honors94816792honors
hons77350782ho_ns
hood85132332ho_od
hoods95124082hoods
hoof106036582ho_of
hoofs115721042hoofs
hook116133282ho_ok
hooks125027122hooks
hoop96129982ho_op
hoops105621072hoops
hoot75752092ho_ot
hoots84830242hoots
hopes105835642hopes
hops97942632ho_ps
horas86333092horas
horns86125332horns
hos68364192h__os
hoses85443172hoses
hosts85526702hosts
hotbox1835692hotbox
hots78349322ho_ts
hours85422382hours
howes114730262howes
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602ho_ws
hoyas115016162hoyas
hoys107733932ho_ys
hubs96027142hub_s
hypos1312014742hypos
jobs136529432job_s
kobo107422102kobo_
kobs105831082kob_s
kolos94921212kolos
kotos95717692kotos
lobes75331002lobes
lobo67229862lobo_
lobs66441082lob_s
locos75822602locos
logos67225332logos
loos49051122lo_os
lotos54724632lotos
mobs85737372mob_s
mojos145314462mojos
monos75930862monos
moos66051302mo_os
mozos165516332mozos
nobs66436902nob_s
nolos54423352nolos
nomos75919742nomos
obas65730932_obas
obes66036832_obes
obis66226842_obis
oboe66822942_oboe
oboes75717712_oboes
obol65220612_obol
obols73715862_obols
onos46229002_onos
phonos114114792phonos
photos113316632photos
poboy121612222poboy
poboys1397312poboys
polos76129912polos
pomos95321582pomos
poos65949112po_os
robes75133302robes
robot7325972robot
robots8313142robots
robs65837872rob_s
rotos56027882rotos
shoos84226352sho_os
sobas74424252sobas
sobs64941752sob_s
solos54830792solos
tholos94213002tholos
topos75726392topos
toros54336192toros
toyos87519142toyos
umbos94613072umbos
woos76238802wo_os
yobbos1335962yobbos
yobs96028082yob_s
zoos135828802zo_os

Search took 2 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 Filter178691538000.0961861364.6
2DLD Change Limit538001551.57634137.1
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.718104011.1
 
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.