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

119 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
hyaloid143907(None) 
haloid104317761h_aloid
hyaloids1545991hyaloids
cycloid1539282cycloid
halid94424982h_al_id
haloed104717602h_aloed
haloids113012552h_aloids
haploid1339832haploid
hyalin122210042hyal_in
hydroid1539712hydroid
hyenoid1448612hyenoid
hyoid12612442hy__oid
hypnoid1647882hypnoid
hyracoid1745972hyracoid
myeloid13108122myeloid
phylloid1746192phylloid
sialoid8310962sialoid
xyloid1738192xy_loid
acaroid103512313acaroid
agatoid948623agatoid
alcid85817973__alcid
algid75415583__algid
algoid83011473__algoid
alkaloid1345293alkaloid
aloin55227423__aloin
aloud65018073__aloud
amyloid1348543amyloid
aroid65428343__aroid
avoid95516683__avoid
chalcid1537883chalcid
cheloid13310833cheloid
colloid10312883colloid
cyanid123912043cya_nid
cycloids1647043cycloids
cymoid1459473cy_moid
cystoid13309213cystoid
diploid11310293diploid
euploid1038963euploid
eyelid1038443eyel_id
gadoid9310463_gadoid
ganoid8314443_ganoid
haemoid1337203haemoid
haled95335823h_al_ed
halide103417993h_al_ide
halids104016133h_al_ids
halloed113314913halloed
halo76437323h_alo__
haloes94623863h_aloes
haloing113814133h_aloing
halon86124863h_alo_n
halons95720713h_alons
halos85230253h_alo_s
halted105019603h_alted
halved134813903h_alved
haploids1437363haploids
haploidy1754273haploidy
hayloft1696963hayloft
healed105121443heal_ed
helloed113512423helloed
hematoid1449753hematoid
hemoid12313513h_emoid
hexaploid22103843hexaploid
hilloed113211293hilloed
histoid1139823histoid
holloed113812753holloed
hulloed11369793hulloed
humanoid1445713humanoid
hyaenic1545993hyaenic
hyaline132310723hyaline
hyalins13229273hyalins
hyalite13229473hyalite
hyalogen1544053hyalogen
hybrid15237813hy_brid
hydatid1546523hydatid
hydrid14248973hy_drid
hydroids1647763hydroids
hyoids1377673hy__oids
hypoed1547923hy_poed
hypoploid2055983hypoploid
hyracoids1844253hyracoids
keloid11812623_keloid
lianoid837533lianoid
loid55531493___loid
meloid9616003_meloid
myalgia13124293myalgia
myalgic15134223myalgic
myceloid1644853myceloid
myoid11512993my__oid
myxoid1936883my_xoid
oceloid1037973oceloid
ozalid1696683ozal_id
pallid93915283_pallid
payload1336403payload
petaloid1148753petaloid
phylloids1844523phylloids
phytoid1678753phy_toid
placoid1239773placoid
pygmoid1644533pygmoid
pyoid11513763py__oid
pyralid1347983pyral_id
pyranoid1447283pyranoid
salpid9510883_salpid
sepaloid1146763sepaloid
sialid7314943sial_id
sloid64619713__sloid
sparoid102311543sparoid
styloid1137553styloid
tabloid1048263tabloid
thalloid1246283thalloid
thylakoid2052053thylakoid
thyreoid1544773thyreoid
thyroid1438253thy_roid
thyrsoid1544193thyrsoid
typhoid1648133typhoid
valgoid1255213_valgoid
valid94618393_val_id
waylaid1445093waylaid
yald86920613_yal__d
zygoid2045943zy_goid

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.406440125.6
2DLD Change Limit1340271196.61020276.4
3Display Results1191190.0303966.7
 (SQL Overall)1786911197.04625360.6
 
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.