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

158 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
hulas8492088(None) 
hula74923751hula_
hulks125715481hulks
hulls84923561hulls
hylas114815901hylas
alas46358122_alas
anlas55626932anlas
atlas55821582atlas
auras55932552auras
balas76937212balas
bolas74733762bolas
bulbs96016932bulbs
bulks115920612bulks
bulls75629572bulls
bunas75126572bunas
buras74736292buras
chelas113817202chelas
cholas114817992cholas
chufas14397672chufas
colas75436772colas
culls75425812culls
culms95314192culms
cults75022552cults
cutlas8313092cutlas
doulas75114992doulas
duals65620082duals
dulias71212742dulias
dulls64523742dulls
dumas85420432dumas
duras65727722duras
fulls84623522fulls
galas65731642galas
gulag7310822gulag
gulags837542gulags
gular6314832gular
gules64831042gules
gulfs94915302gulfs
gulls65222982gulls
gulps84715072gulps
guls55930852gul_s
hahas117118442hahas
halal85623592halal
halals95018312halals
hales85449842hales
halls85633782halls
halmas117017892halmas
halms105225212halms
halos85230252halos
halts85230102halts
halvas124714172halvas
has67372652h__as
haulms11558502haulms
hauls86123732haul_s
heals85733452heals
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
hila76228352hila_
hilar85418142hilar
hills85431352hills
hilts86924412hilts
hilus84817642hilus
holds94623242holds
holes84748652holes
holks124720562holks
hollas94616902hollas
holms105117802holms
hols76946292hol_s
holts85627912holts
horas86333092horas
hoyas115016162hoyas
hubs96027142hu_bs
hucks144322172hucks
hues75235232hu_es
huffs144514742huffs
hugs86129752hu_gs
hulk115321612hul_k
hulky155312472hulky
hull75428782hul_l
hullo84417452hullo
hulloas103911912hulloas
hullos94916292hullos
human102716032human
humans112312432humans
humps126322802humps
hums96831422hu_ms
humus106215072humus
hunks125321452hunks
huns76136932hu_ns
hunts86826172hunts
hurds95219072hurds
hurls86522712hurls
hurts86922822hurts
husks125015452husks
huts76737442hu_ts
huzzas1735862huzzas
hyla106716512hyla_
jubas144614222jubas
judas134911882judas
kolas94822232kolas
kulak858822kulak
kulaks976112kulaks
las37281472__las
lulls54119652lulls
lulus54315162lulus
lumas75622912lumas
lunas55025012lunas
molas75132092molas
mules75034292mules
mullas84215932mullas
mulls75124152mulls
muras75329562muras
nalas55528362nalas
nulls55019982nulls
ollas54218282ollas
pujas145513322pujas
pula65129372pula_
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pul_s
pumas95121562pumas
punas74826752punas
pupas95219282pupas
rules55234252rules
shuls85319712shul_s
subas74724072subas
sulfas9311562sulfas
sulks94818462sulks
sulus54821882sulus
suras55336322suras
talas55935892talas
thujas1634432thujas
thulias1035742thulias
thuyas1234772thuyas
tolas54532772tolas
tubas75119572tubas
tufas85314382tufas
tules54532792tules
tunas54224122tunas
uhlan849112uhlan
uhlans937572uhlans
ulan46527392_ulan
ulans54921302_ulans
ulnas55716532_ulnas
ulus45622562_ulus
ulvas84511502_ulvas
upas68322382_upas
utas45924952_utas
uvulas946522uvulas
vulvas12388842vulvas
yucas106013912yucas
yugas95012062yugas
yulan8411492yulan
yulans958672yulans
yules84521582yules

Search took 4 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 Filter178691538000.1701051123.5
2DLD Change Limit538001583.61014903.0
3Display Results1581580.0463434.8
 (SQL Overall)1786911583.82646704.4
 
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.