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

415 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
halloo9511897(None) 
hallo85127551hall_o
halloa94918121halloa
halloos103716741halloos
hallos95425101hallos
hallot95426781hallot
hallow124818321hallow
holloo94415251holloo
hulloo94511731hulloo
allod64418382_allod
allot54933872_allot
allow85420662_allow
alloy85519972_alloy
ballon84117492ballon
balloon93711432balloon
ballot84624092ballot
callow114714662callow
challot123613262challot
fallow124713852fallow
gallon73715812gallon
galloon82910642galloon
galloot82814222galloot
gallop93311382gallop
hall75741162hall__
hallah124115402hallah
hallal94415562hallal
hallel93514092hallel
halloas104318462halloas
halloed113314912halloed
halloes104021522halloes
hallooed12168772hallooed
halloth134111252halloth
hallows134417392hallows
halls85633782hall_s
hallux1637362hallux
halo76437322ha_l_o
halon86124862ha_lon
halos85230252ha_los
harlot94422802harlot
hello86522982hell_o
hellos95321682hellos
hillo84721652hill_o
hilloa94713032hilloa
hillos94618892hillos
hollo84822162holl_o
holloa94914822holloa
holloos104013582holloos
hollos95320632hollos
hollow124212662hollow
hullo84417452hull_o
hulloa95011182hulloa
hulloos104010072hulloos
hullos94916292hullos
mallow114014742mallow
pallor8313682pallor
sallow94315752sallow
shalloon1145682shalloon
shallop12348452shallop
shallot103614132shallot
shallow13388872shallow
tallol63612222tallol
tallow93714202tallow
wallop113310292wallop
wallow123913512wallow
abloom1039783_abloom
achoo10315083_achoo
aglow94711973_aglow
ahchoo1445713ahchoo
alamo7418143_alamo
aldol61212333_aldol
algor6513053_algor
all36148233_all__
allay85620393_allay
allee54932123_allee
alley85721673_alley
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
alls46740923_all_s
ally76935643_all_y
allyl85310543_allyl
aloe45540193_a_loe
aloof83521573_aloof
alow75328593_a_low
also46423443_a_lso
altho86312603_altho
alto47831263_a_lto
altos55822953_altos
azlon144312873_azlon
baboo94319503ba_boo
bailor83412603bailor
balboa10389963balboa
ball66043323ball__
ballad94315323ballad
balled94926893balled
baller83825203baller
ballet84733973ballet
ballons93916963ballons
balloons103110523balloons
ballots94116033ballots
ballroom1245033ballroom
balls76236413ball_s
ballsy11508873ballsy
bally105530103ball_y
ballyhoo1643193ballyhoo
bamboo12310013bamboo
barlow112911433barlow
bazoo163815673ba_zoo
bellow114213353bellow
billon83713833billon
billow114111223billow
bollox1548743bollox
calico103414433calico
call66838673call__
calla74827073call_a
callaloo1044903callaloo
callan83619603callan
callas84526753callas
callboy1465833callboy
called94126733called
callee84327293callee
caller85125483caller
callet84536763callet
callose9313663callose
callous93516603callous
calls75634733call_s
callus85317073callus
calo64936443ca_l_o
calos74431903ca_los
cashoo11312253cashoo
cello74919583cell_o
cellos84517803cellos
challa114014193chall_a
challah15458323challah
challas124414123challas
challie124012853challie
challis124613463challis
challoth16316103challoth
chally144314293chall_y
chalot113020133cha_lot
collop107312313collop
dalles74222063dalles
dally95324743dall_y
dalton7311273dalton
dollop9259363dollop
falcon11310293falcon
fall75535313fall__
fallal93612693fallal
fallen93813373fallen
faller94621233faller
falloff1245953falloff
fallout10313503fallout
fallows133713973fallows
falls85727653fall_s
felloe93513923felloe
fellow123712743fellow
fillo84319783fill_o
fillos94415083fillos
follow124010353follow
galago838913galago
galiot72322593galiot
gall56335993gall__
galled84622863galled
galleon8278713galleon
gallet73630853gallet
galley104215453galley
gallic9411643gallic
galliot82214143galliot
gallons83015953gallons
galloons9289703galloons
galloots9268963galloots
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galls64729323gall_s
gallus74313203gallus
gally95026173gall_y
galoot72719163galoot
galop84716223ga_lop
gazoo153112873ga_zoo
haboob1377883haboob
hadron102913753hadron
hagdon1188283hagdon
hail74839063hail__
hailed104122743hailed
hailer94720343hailer
hails85231643hail_s
hairdo1036433hairdo
halal85623593ha_lal
halala94715093halala
halalah13429393halalah
halalas104214083halalas
halals95018313halals
halcyon1543923halcyon
hale76052833ha_l_e
haled95335823ha_led
haler85033533ha_ler
halers94926923halers
haleru94212083haleru
hales85449843ha_les
halest94823273halest
half106238453ha_l_f
halid94424983ha_lid
halide103417993halide
halidom1386453halidom
halids104016133halids
haling104229783haling
halite93624233halite
hallahs133912463hallahs
hallels103310133hallels
halloaed121510153halloaed
halloing121510073halloing
hallooing1366343hallooing
hallowed15179503hallowed
hallower14139823hallower
hallway1636173hallway
halm95834973ha_l_m
halma108219263ha_lma
halmas117017903halmas
halms105225213ha_lms
haloed104717603haloed
haloes94623863haloes
haloid104317763haloid
halons95720713halons
halt76056303ha_l_t
halted105019603halted
halter94420883halter
halts85230103ha_lts
halutz1868853halutz
halva115414433ha_lva
halvah15499833halvah
halvas124714173halvas
halve114818923ha_lve
halved134813903halved
halves124717093halves
hamlet113722793hamlet
handloom1444613handloom
hansom11219153hansom
hao67251123ha___o
haole84820083haol_e
haoles94919803haoles
haploid1339833haploid
haplont12412563haplont
haply135915063hapl_y
harbor11410723harbor
harl75740003harl__
harlots103413293harlots
harls85634503harl_s
harpoon1238313harpoon
harrow122610783harrow
haslet93222713haslet
hatbox1835133hatbox
haul75530453haul__
hauled104415213hauled
hauler95015123hauler
haulm104415413haul_m
haulms11558503haulms
haulmy14455553haulmy
hauls86123733haul_s
havior1248203havior
havoc1337183ha_voc
hayloft1696963hayloft
haymow1773683haymow
helio85321193h_elio
helios94816633helios
hell75637893hell__
hellbox1944993hellbox
helled104024703helled
heller93322513heller
hellion10311143hellion
helloed113512433helloed
helloes103717473helloes
hells85032043hell_s
helo75332853h_el_o
helos84928063h_elos
helot85332683h_elot
hill76439503hill__
hilled104022223hilled
hiller94421633hiller
hilloas104413553hilloas
hillock1646693hillock
hilloed113211293hilloed
hilloes103815963hilloes
hills85431353hill_s
hilltop1244783hilltop
hilly114422163hill_y
holla84918493holl_a
hollas94616903hollas
holler93520613holler
holloas103814943holloas
holloed113812753holloed
holloes103818193holloes
hollooed12146493hollooed
hollows134412333hollows
holly114824433holl_y
hoodoo10109983hoodoo
hoopoo1198753hoopoo
hull75428783hull__
hulled103920013hulled
huller93919103huller
hulloas103911913hulloas
hulloed11369793hulloed
hulloes104113923hulloes
hullooed12135093hullooed
hulls84923563hull_s
igloo6410493_igloo
jailor13418573jailor
jalop144212603ja_lop
jello126716273jell_o
jellos134714283jellos
karoo92519593ka_roo
karroo10410023karroo
kazoo183311533ka_zoo
lall45531313lall__
lallan63414183lallan
lalled74218753lalled
lalls55324133lall_s
lollop8238783lollop
loo38359823___loo
maillot9312173maillot
mall64639373mall__
malled94626113malled
mallee84525593mallee
mallei84414633mallei
mallet84433053mallet
mallows123714323mallows
malls76233433mall_s
maltol8310843maltol
mellow114112223mellow
pall65039343pall__
palled94625163palled
pallet84232653pallet
pallia83015603pallia
pallid93915293pallid
pallors9314373pallors
palls74332563pall_s
pally105727123pall_y
parlor8312683parlor
phalli1148263phall_i
phallic1447293phallic
phallus1236063phallus
phyllo1435873phyll_o
phyllos1535583phyllos
pillow113110573pillow
rally84725903rall_y
rallye95110163rallye
reallot7312133reallot
sailor63113753sailor
sall44544683sall__
sallet63734543sallet
sallows103915553sallows
sallowy13369343sallowy
sally85129713sall_y
salmon84614183salmon
salol55222143sa_lol
salols64017873salols
salon55228553sa_lon
saloon64418023saloon
saloop84212583saloop
salvo84415643sa_lvo
salvor94711093salvor
salvos94613383salvos
sawlog1035793sawlog
scallop11237643scallop
shall85024053shall__
shalloons1245223shalloons
shallops13288323shallops
shallots11319503shallots
shallows14388863shallows
shalom11810923sha_lom
shampoo1435373shampoo
slalom888173slalom
swallow13355753swallow
taboo73418093ta_boo
tailor63412503tailor
talion6317713talion
tall47240213tall__
tallboy1265143tallboy
taller63721963taller
tallis63319963tallis
tallit63422733tallit
tallols73311363tallols
tallows103313743tallows
tallowy13347633tallowy
talls55133433tall_s
tally84526863tall_y
tallyho1343043tallyho
talon55824113ta_lon
tattoo6310973tattoo
thalli958923thall_i
thallic1246553thallic
thalloid1246283thalloid
thallous1136523thallous
thallus1035603thallus
unhallow14112343unhallow
valley124311603valley
valor83614893va_lor
wahoo112413083wa_hoo
wall76236103wall__
walla85321033wall_a
wallah124011993wallah
wallaroo1144623wallaroo
wallas95719393wallas
walled104021293walled
wallet93327093wallet
wallie93216803wallie
wallops123410413wallops
wallows133613533wallows
walls85529383wall_s
wally114625093wall_y
wazoo173011173wa_zoo
willow12369693willow
yahoo112911543ya_hoo
yellow12429883yellow

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.390458182.1
2DLD Change Limit1127164156.00018786.0
3Display Results4154150.1402964.3
 (SQL Overall)1786914156.53027364.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.