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

227 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
hobbit13281053(None) 
hobbits14317551hobbits
bobbin93410732bobbin
dobbin11339522dobbin
gobbet114214442gobbet
habit103027022h_abit
henbit111412002henbit
hobbed144114302hobbed
hobber134114632hobber
hobbies143813342hobbies
hobbing152811122hobbing
hobble133913432hobble
hobby155913732hobb_y
hobbyist1843472hobbyist
howbeit1545662howbeit
obit66837082_o_bit
orbit73622062_orbit
rabbit102914562rabbit
robbin103611182robbin
sobeit8315342sobeit
abbot9318453_abbot
albeit8314343albeit
ambit94223713_ambit
babbitt1038033babbitt
bait66556003__bait
bit57070903___bit
bobbed104315833bobbed
bobber95016743bobber
bobbies103714563bobbies
bobbinet1157903bobbinet
bobbing113113193bobbing
bobbins103410343bobbins
bobble94115143bobble
bobby114814663bobb_y
bobcat12411253bobcat
boobie104015293boobie
brit66350153__brit
cabbie122913353cabbie
cobalt10317393cobalt
cobb106422003cobb__
cobber124116843cobber
cobbier133410163cobbier
cobbiest14118523cobbiest
cobble123615263cobble
cobbs115013993cobb_s
cobby145516413cobb_y
cobia94117513co_bia
cobnut10311313cobnut
coedit9316233coedit
cohabit1449563cohabit
combat12316753combat
comfit133112423comfit
commit124016703commit
confit113316403confit
corbie103618203corbie
cubit94122893_cubit
debit85727853_debit
deorbit1048163deorbit
dhobi1136963dho_bi_
dhobis1236103dho_bis
dobber114015413dobber
dobbies124113063dobbies
dobbins12379533dobbins
dobby136013633dobb_y
dobie84920333do_bie
doit56347853do__it
doobie94712683doobie
doubt8720093doub_t
dubbin11329263dubbin
ebbet93517293_ebbet
fobbed144112613fobbed
fobbing153410273fobbing
forbid123312433forbid
forrit91916623forrit
gambit114714203gambit
gibbet114113383gibbet
gobbed124613883gobbed
gobbets12327643gobbets
gobbing132910703gobbing
gobble113512983gobble
goblet93219483goblet
goblin939503goblin
godwit1137513godwit
habits113014653h_abits
haffit1538533haffit
hagbut1278913hagbut
henbits12177003henbits
hermit11519443hermit
hit66569193h___it
hoagie102310003hoagie
hob87550923ho_b__
hobbers143512343hobbers
hobbled153310783hobbled
hobbler143710403hobbler
hobbles143313783hobbles
hobbling16227583hobbling
hobbyists1942243hobbyists
hoblike16158303hoblike
hobnail1243973hobnail
hobnob1335133hobnob
hobo97026083ho_b_o
hoboed124511683hoboed
hoboes114717443hoboes
hoboing13309453hoboing
hoboism1446613hoboism
hobos106321353ho_bos
hobs97038983ho_b_s
hoddin11369933hoddin
hogget114715763hogget
hognut1039413hognut
hogtie102711763hogtie
hoist86433213ho_ist
holibut1297483holibut
holist94723213holist
holmic1338773holmic
holt77852583ho__lt
hombre13309303hombre
homie104622523ho_mie
honest94822423honest
hongi96715853hongi_
honkie133011663honkie
hoodie105116133hoodie
hoolie93217773hoolie
hoot75752093ho__ot
hoplite12311073hoplite
hornet94926433hornet
hornist102314823hornist
hornito1047073hornito
horrid10311553horrid
horst85833513ho_rst
host77852833ho__st
hot67776053ho___t
hotbed123310673hotbed
hotbox1835693hotbox
hottie92514363hottie
houri85915233houri_
houris94514563houris
howdie13349723howdie
howlet123518343howlet
hubbies143211563hubbies
hubbly16478413hubbly
hubbub1243603hubbub
hubby155011403hubb_y
hubris11218973hubris
hybrid15237813hybrid
hybris14247003hybris
jobbed184212133jobbed
jobber173813353jobber
jobbing19279013jobbing
kebbie1435813kebbie
kibbi13449273kibbi_
kibbis14398473kibbis
kibbitz2443953kibbitz
lobbed113114613lobbed
lobber104016603lobber
lobbied12337173lobbied
lobbies113612463lobbies
lobbing123110913lobbing
lobby125113923lobb_y
lobbyist1543533lobbyist
mobbed137112243mobbed
mobber123613463mobber
mobbing14299703mobbing
mobbish1635923mobbish
mobbism1535053mobbism
morbid112511463morbid
nobbier11309163nobbier
nobbiest12117773nobbiest
nobbily1436693nobbily
nobble103814313nobble
nobby125513463nobb_y
nubbin10308293nubbin
obi57127733_o_bi_
obia67923113_o_bia
obis66226843_o_bis
obits74617553_o_bits
objet141213143_objet
oboist8312683_oboist
omit65337373_o_mit
orbits84211443_orbits
phobia13278593pho_bia
phobic153010063pho_bic
posit75833333po_sit
probit103218353probit
qubit164218993_qubit
rabbet103818653rabbet
rabbi93113183rabbi_
rabbin103112303rabbin
rabbis102613163rabbis
rabbits11299863rabbits
rabbity14266303rabbity
rebait8320403rebait
rhombi13365193rhombi_
rhombic16264523rhombic
robbed113415193robbed
robber103916533robber
robbing123313213robbing
robbins112811063robbins
robin74820283ro_bin
robot7325973ro_bot
robust8310433robust
sabbat10314713sabbat
showbiz2453203showbiz
sobbed113516263sobbed
sobber104016583sobber
sobbing127612883sobbing
soffit1237873soffit
sorbet83924073sorbet
sorbic10310383sorbic
submit10312673submit
tabbis102910863tabbis
tidbit938493tidbit
titbit839823titbit
toit46353063to__it
tomtit8413853tomtit
turbit8715113turbit
vomit102622573vo_mit
wobble133212313wobble
wobbly16347093wobbly
wombat1339863wombat
worrit92313313worrit
yabbie13308663yabbie
yobbo1237873yobb_o
yobbos1335963yobbos
zombi1838993zombi_
zombie1937323zombie
zombis1936283zombis

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162276.48317386.4
3Display Results2272270.0633603.2
 (SQL Overall)1786912276.68626726.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.