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

264 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
hulloa9501118(None) 
halloa94918121halloa
hilloa94713031hilloa
holloa94914821holloa
hullo84417451hullo_
hulloas103911911hulloas
hulloo94511731hulloo
hullos94916291hullos
bulla74620562bull_a
hallo85127552hallo_
halloas104318462halloas
halloo95118972halloo
hallos95425102hallos
hallot95426782hallot
hallow124818322hallow
hello86522982hello_
hellos95321682hellos
hillo84721652hillo_
hilloas104413542hilloas
hillos94618882hillos
holla84918492holl_a
hollo84822162hollo_
holloas103814942holloas
holloo94415252holloo
hollos95320632hollos
hollow124212662hollow
hula74923752hu_l_a
hull75428782hull__
hulled103920012hulled
huller93919102huller
hulloaed12105802hulloaed
hulloed11369792hulloed
hulloes104113922hulloes
hulloos104010072hulloos
hulls84923562hull_s
mulla74317112mull_a
ahull84010313ahull__
allod64418373_allod
allot54933873_allot
allow85420663_allow
alloy85519973_alloy
alula5317093alul_a
balboa10389963balboa
ballon84117493ballon
ballot84624093ballot
bellow114213353bellow
bilboa10367843bilboa
billon83713823billon
billow114111223billow
bollox1548743bollox
bull65634873bull__
bullae83416163bullae
bullbat1158553bullbat
bulldog1174253bulldog
bulled94626493bulled
bullet84528613bullet
bullion91911033bullion
bullock1537193bullock
bullous9311663bullous
bulls75629573bull_s
bully105124813bull_y
busload1044683busload
calla74827073call_a
callow114714663callow
cella75420313cell_a
cello74919583cello_
cellos84517803cellos
challa114014193chall_a
challot123613263challot
cholla113911023choll_a
collop107312313collop
cull65929643cull__
cullay113910173cullay
culled94022473culled
culler84322253culler
cullet84727313cullet
cullion91910233cullion
cullis84115993cullis
culls75425813cull_s
cully105520463cull_y
culpa93610963cu_lpa
cupola10317693cupola
dollop9259363dollop
duello756783duello_
duellos845763duellos
dulia61014983du_lia
dull56430443dull__
dulled84719423dulled
duller74017703duller
dulls64523743dull_s
dully94921633dull_y
duolog835803duolog
fallow124713853fallow
fella84918653fell_a
felloe93513923felloe
fellow123712743fellow
fillo84319783fillo_
fillos94415073fillos
follow124010353follow
fulcra1135213fulcra
full75229153full__
fullam1138363fullam
fulled103820653fulled
fuller94220383fuller
fulls84623523full_s
fully114820863full_y
gallon73715813gallon
gallop93311383gallop
gull54828453gull__
gulled84521373gulled
gullet74924833gullet
gulley104213163gulley
gulls65222983gull_s
gully94020683gull_y
halala94715093halala
hall75741163hall__
hallah124115403hallah
hallal94415563hallal
hallel93514093hallel
halloaed121510153halloaed
halloed113314913halloed
halloes104021513halloes
halloos103716743halloos
halloth134111253halloth
hallows134417393hallows
halls85633783hall_s
hallux1637363hallux
hallway1636173hallway
halma108219253h_alma
halo76437323h_alo_
halon86124863h_alon
halos85230253h_alos
halva115414433h_alva
harlot94422803harlot
helio85321193helio_
helios94816633helios
hell75637893hell__
hellbox1944983hellbox
hellcat12410173hellcat
helled104024703helled
heller93322513heller
hellion10311133hellion
helloed113512423helloed
helloes103717453helloes
hells85032043hell_s
helluva1353533helluva
helo75332853h_elo_
helos84928063h_elos
helot85332683h_elot
hila76228353h_il_a
hill76439493hill__
hilled104022223hilled
hiller94421633hiller
hilloaed12136923hilloaed
hillock1646693hillock
hilloed113211293hilloed
hilloes103815943hilloes
hills85431353hill_s
hilltop1244783hilltop
hilly114422163hill_y
hollas94616903hollas
holler93520613holler
holloaed12157393holloaed
holloed113812753holloed
holloes103818193holloes
holloos104013583holloos
hollows134412333hollows
holly114824433holl_y
hulas84920883hu_las
hulk115321613hu_l_k
hulked144611303hulked
hulks125715483hu_lks
hulky155312473hu_lky
hullers103616263hullers
hulling113619013hulling
hulloaing1384523hulloaing
hulloing12146703hulloing
hullooed12135093hullooed
humor101110513hu_mor
hurl76029933hurl__
hurled104617453hurled
hurler94717223hurler
hurley125012523hurley
hurls86522713hurl_s
hurly115819293hurl_y
hutzpa2052803hutzpa
huzza1646093hu_zza
hyla106716513h_yl_a
jello126716273jello_
jellos134714283jellos
lollop8238783lollop
lull44225763lull__
lulled74516443lulled
luller63415483luller
lulls54119653lull_s
mallow114014743mallow
mellow114112223mellow
muleta839233muleta
mull65128803mull__
mullah113710733mullah
mullas84215933mullas
mulled94721553mulled
mullen83714763mullen
muller83820353muller
mullet84126823mullet
mulley114013453mulley
mullion91911173mullion
mullock1535713mullock
mulls75124153mull_s
null45125313null__
nullah9388143nullah
nulled74318273nulled
nulls55019983null_s
olla44821173_oll_a
pallia83015593pallia
pallor8313673pallor
phyllo1435873phyllo_
phyllos1535583phyllos
pillow113110573pillow
pula65129373pu_l_a
pull64731663pull__
pulled94322193pulled
puller83820813puller
pullet84026333pullet
pulley113713403pulley
pullman1135403pullman
pullout9310593pullout
pulls74425053pull_s
pullup1045893pullup
putlog965553putlog
qualia1559563qualia
quelea1547303quelea
quinoa15377653quinoa
rugola736293rugola
sallow94315753sallow
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
sublot82315523sublot
sulfa8313923su_lfa
sulfo8313363sulfo_
sullen62914293sullen
sully84622893sull_y
sulpha1135403sulpha
tallol63612223tallol
tallow93714203tallow
thulia936113thu_lia
tulle54019933tull_e
tulles63218893tulles
ulama7711473_ulama
ulema7109713_ulema
ulna46317323_u_lna
ultra539363_ultra
ulva75412693_u_lva
unload73010803_unload
upload9257783_upload
villa85321233vill_a
vulgo936953vulgo_
vulva11448803vu_lva
walla85321033wall_a
wallop113310293wallop
wallow123913513wallow
willow12369693willow
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.1431249587.4
2DLD Change Limit1127162646.62317018.9
3Display Results2642640.1262095.2
 (SQL Overall)1786912646.89225927.3
 
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.