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

212 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
hobbits1431755(None) 
hobbies143813341hobbies
hobbit132810541hobbit_
bobbies103714562bobbies
bobbins103410342bobbins
dobbies124113062dobbies
dobbins12379532dobbins
gobbets12327642gobbets
habits113014652h_abits
henbits12177002henbits
hobbers143512342hobbers
hobbing152811122hobbing
hobbles143313782hobbles
hobbyist1843472hobbyist
hobbyists1942242hobbyists
hubbies143211562hubbies
lobbies113612462lobbies
obits74617552_o_bits
orbits84211442_orbits
rabbits11299862rabbits
robbins112811062robbins
abbots1039283_abbots
ambits103713413_ambits
babbitt1038033babbitt
babbitts1144023babbitts
baits76630583__baits
bits66148163___bits
bobbers103614283bobbers
bobbin93410733bobbi_n
bobbinets1243073bobbinets
bobbing113113193bobbing
bobbles104514913bobbles
bobcats1335993bobcats
boobies113718203boobies
brits76433083__brits
bubbies103913513bubbies
cabbies133115163cabbies
cobalts1139203cobalts
cobbers134114753cobbers
cobbier133410163cobbier
cobbiest14118523cobbiest
cobbles133814823cobbles
cobbs115013993cobb__s
cobias104014993co_bias
cobnuts1135353cobnuts
coedits10310243coedits
cohabits1545413cohabits
combats13311683combats
comfits14328743comfits
commits133812383commits
confits122811423confits
corbies113520123corbies
cubbies133312883cubbies
cubits103714033_cubits
debits94214503_debits
deorbits1144613deorbits
dhobis1236113dho_bi_s
dobbers123513253dobbers
dobbin11339523dobbi_n
dobies94422093do_bies
doits66223673do__its
doobies103915673doobies
doubts968733doub_ts
dubbins12358803dubbins
ebbets10376833_ebbets
fobbing153410273fobbing
forbids13268263forbids
gambits12399723gambits
gibbets12417723gibbets
gobbet114214443gobbet_
gobbing132910703gobbing
gobbles123512583gobbles
gobies95418063go_bies
goblets103210183goblets
goblins1039243goblins
godwits1234133godwits
habit103027023h_abit_
habitus12338173h_abitus
haffits1636193haffits
hagbuts1354933hagbuts
henbit111412003henbit_
hermits12312143hermits
hits75545133h___its
hoagies112811993hoagies
hobbed144114303hobb_ed
hobber134114633hobb_er
hobble133913433hobb_le
hobbled153310783hobbled
hobbler143710403hobbler
hobblers15308513hobblers
hobbling16227583hobbling
hobby155913733hobb__y
hoblike16158303hoblike
hobnails1343303hobnails
hobnobs1443603hobnobs
hoboes114717443ho_boes
hoboing13309453hoboing
hoboism1446623hoboism
hoboisms1545563hoboisms
hobos106321353ho_b_os
hobs97038983ho_b__s
hoddins12289373hoddins
hoggets12498323hoggets
hognuts1134183hognuts
hogties112813993hogties
hoist86433213ho__ist
hoists95516023ho_ists
holibuts1363953holibuts
holies94630033ho_lies
holist94723213ho_list
holists104413963holists
hollies103420813hollies
holts85627913ho__lts
hombres14369873hombres
homies114524723ho_mies
hongies112716473hongies
honkies143015143honkies
hoodies113419833hoodies
hookies144017443hookies
hoots84830253ho__ots
hoplite12311073hoplite
hoplites13310543hoplites
hornets104113553hornets
hornist102314823hornist
hornists11208833hornists
hornito1047073hornito
hornitos1145393hornitos
horsts95817513ho_rsts
hosts85526703ho__sts
hotbeds13315003hotbeds
hots78349333ho___ts
hotties103016963hotties
houris94514583houri_s
howbeit1545663howbeit_
howdies142911953howdies
howlets13329223howlets
hubbubs1342603hubbubs
hubris11218973hubri_s
hybrids16236023hybrids
hybris14247003hybri_s
jobbers182911133jobbers
jobbing19279013jobbing
kebbies1537253kebbies
kibbis14398473kibbi_s
kibbitz2443953kibbitz
lobbers113713943lobbers
lobbied12337173lobbied
lobbing123110913lobbing
lobbyist1543533lobbyist
lobbyists1642193lobbyists
loobies93814103loobies
mobbers133610923mobbers
mobbing14299703mobbing
mobbish1635923mobbish
mobbism1535053mobbism
mobbisms1643773mobbisms
nobbier11309163nobbier
nobbiest12117773nobbiest
nobbily1436693nobbily
nobbles114014523nobbles
nubbins11268023nubbins
obias76116863_o_bias
obis66226843_o_bi_s
obit66837083_o_bit_
objets15125323_objets
oboist8312683_oboist
oboists937903_oboists
omits75018263_o_mits
orbit73622063_orbit_
phobias14228183pho_bias
phobics16286703pho_bics
posits85718713po_sits
probits112712573probits
qubits173710353_qubits
rabbets11279423rabbets
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613163rabbi_s
rabbit102914563rabbit_
rabbity14266303rabbity
rebaits9312573rebaits
robbers112814163robbers
robbin103611183robbi_n
robbing123313213robbing
robins83617453ro_bins
robots8313153ro_bots
rubbies114114113rubbies
sabbats1138633sabbats
sobbers114114263sobbers
sobbing127612883sobbing
sobeit8315363sobeit_
soffits1335093soffits
sorbets93012513sorbets
submits1139753submits
tabbies112913503tabbies
tabbis102910863tabbi_s
tidbits1035183tidbits
titbits935803titbits
tobies84521023to_bies
toits55327473to__its
tomtits937243tomtits
turbits969233turbits
vomits112610923vo_mits
wobbles143412433wobbles
wobblies15297233wobblies
wombats1435893wombats
worrits10258683worrits
yabbies14279643yabbies
yobboes1445583yobboes
yobbos1335963yobb_os
zombies2037993zombies
zombis1936283zombi_s

Search took 8 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.440406115.9
2DLD Change Limit1340272126.81019680.9
3Display Results2122120.0802650.0
 (SQL Overall)1786912127.33024378.0
 
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.