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

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
hobo9702608(None) 
gobo76126901gobo
hob87550921hob_
hobos106321351hobos
hobs97038981hobs
homo96126471homo
kobo107422101kobo
lobo67229861lobo
abo59045962_abo
adobo84711592adobo
ambo88225142ambo
bo410957572__bo
bob76755672bob_
bobs86340652bobs
boho96923322boho
bolo65535952bolo
boo58163662bo_o
boob85932582boob
boyo96923842boyo
bozo156821412bozo
bubo85621912bubo
cholo105217972cholo
cob710258752cob_
cobb106422002cobb
cobs87043142cobs
coco87330602coco
coho97524492coho
combo114519432combo
coo59566362co_o
dhobi1136972dhobi
dobro84412212dobro
doby106022162doby
dodo66024912dodo
dojo126016142dojo
fob86748332fob_
fobs96034272fobs
gob68950892gob_
gobos86219382gobos
gobs76935572gobs
goby106021082goby
gogo69722832gogo
gombo105814042gombo
goo47754772go_o
habu97325482habu
halo76437322halo
hao67251122h_ao
hebe96424702hebe
helo75332852helo
hero74635782hero
ho510258272h__o
hoar76729162hoar
hoax147718292hoax
hobby155913732hobby
hobnob1335132hobnob
hoboed124511682hoboed
hoboes114717442hoboes
hock136031302hock
hod76852462ho_d
hods87239862hods
hoe67562722ho_e
hoed87837982hoed
hoer76533982hoer
hoes75755732hoes
hog78049062ho_g
hogg96617532hogg
hogs87139662hogs
hoke115935932hoke
hold86235062hold
hole77553392hole
holk116027942holk
hollo84822162hollo
holm95628112holm
holp95727552holp
hols76946292hols
holt77852582holt
holy106333432holy
home98042442home
homos105921782homos
homy126623222homy
hon67759382ho_n
hone77549322hone
hong85833952hong
honk116931192honk
honor85718622honor
hons77350782hons
hood85132332hood
hoof106036582hoof
hook116133282hook
hoop96129982hoop
hoot75752102hoot
hop87554592ho_p
hope96639672hope
hops97942632hops
hora76136562hora
horn76735612horn
hos68364192ho_s
hose76547242hose
host77852832host
hot67776062ho_t
hotbox1835702hotbox
hots78349332hots
hour75827312hour
hove107132222hove
how97252432ho_w
howe106734102howe
howf136127202howf
howk145221962howk
howl107625692howl
hows106345602hows
hoy97447912ho_y
hoya107418372hoya
hoys107733932hoys
hub86437482hub_
hubs96027142hubs
hypo127516352hypo
job128041772job_
jobs136529432jobs
kob99442382kob_
kobos115616892kobos
kobs105831082kobs
kolo87026222kolo
koto86323472koto
lob57154462lob_
lobe65535362lobe
lobos75921842lobos
lobs66441082lobs
loco67030742loco
logo57931762logo
loo38359822lo_o
mob78651922mob_
mobs85737372mobs
mojo136917222mojo
mono66036722mono
moo58460512mo_o
mozo157719742mozo
nob58954422nob_
nobs66436902nobs
nolo46229312nolo
noo37154042no_o
oba57531552_oba
obe56638642_obe
obi57127732_obi
oboe66822942_oboe
obol65220612_obol
oho66534382_oho
ono36838032_ono
oxo107322962_oxo
phono104917022phono
photo104417232photo
poboy121612222poboy
poco86826152poco
polo66236632polo
pomo85828452pomo
poo57757112po_o
rob56754302rob_
robe65335642robe
robot7325972robot
robs65837872robs
roto45935052roto
shoo75929892sho_o
sob57857942sob_
soba64927922soba
sobs64941752sobs
solo45538942solo
sybo9714742sybo
thoro86217872thoro
toby96322292toby
too38965422to_o
topo66932402topo
toro48045682toro
toyo76925452toyo
umbo85516662umbo
whoso11509222whoso
woo66949802wo_o
yob87945272yob_
yobbo1237872yobbo
yobs96028082yobs
zoo126238912zo_o

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 Filter178691298720.266671770.7
2DLD Change Limit298721780.76638997.4
3Display Results1781780.0463869.6
 (SQL Overall)1786911781.078165761.6
 
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.