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

151 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
hyaena123536(None) 
hyaenas1334981hyaenas
hyena11810251hy_ena
faena85014202_faena
fraena938062fraena
haen76229452h_aen_
hyaenic1545992hyaenic
hyenas1288952hy_enas
hymen13311042hymen_
hymenal1545182hymenal
hymenia1546392hymenia
hymens1437992hymens
amarna839793amarna
ana39559823__a_na
anna45529013__anna
arena55323813_arena
asana5315483asa_na
bwana10310243bwa_na
caeca93915133_caeca
canna75919333_canna
catena8312473catena
chaeta11310683chaeta
choana1138443choa_na
cyan96419623cya_n_
cyano105512493cya_no
cyans105714813cya_ns
cymene1377393cymene
dharna1055263dharna
dracena1034923dracena
eyen76223663ey_en_
faenas94412763_faenas
fauna84816513_fauna
frena85915273_frena
gaen57329603_gaen_
galena74911093galena
goanna736653goanna
grana65722093gra_na
gyrene10227243gyrene
hae67364003h_ae__
haed86338583h_ae_d
haeing104118923h_aeing
haem95730983h_ae_m
haemal113811643h_aemal
haems105517013h_aems
haes77651023h_ae_s
haet75659503h_ae_t
haets86525123h_aets
haha107821063h_a_ha
haika125313793h_aika
haint85436323h_aint
halma108219253h_alma
halva115414433h_alva
hamza19139773h_amza
hand86833703h_a_nd
hang85535543h_a_ng
hank115134133h_a_nk
hansa85416783h_ansa
hant75461583h_a_nt
haunt85229133h_aunt
haven114718533haven_
havens124514043havens
hayed125822013haye_d
hayer114620243haye_r
hayers124415943hayers
hayey144812533haye_y
haying134420613haying
hazan173813613h_azan
headend12398363headend
heaven123912603heaven_
heavens13439303heavens
hen67555273h__en_
henna84414043h_enna
hens75642573h__ens
hent76656383h__ent
hetaera1036493hetaera
hosanna1044063hosanna
hosen85623883hosen_
hoyden13328933hoyden_
hoydens14347403hoydens
hryvna1541573hryvna
hwan105716893hwa_n_
hyalin122210033hyalin
hyaline132310723hyaline
hyalins13229273hyalins
hydra12249223hy_dra
hydria13227903hydria
hyenic1438723hy_enic
hyetal1236543hy_etal
hygiene1443473hygiene
hying126514743hy_ing
hyla106716513hy__la
hymeneal1643473hymeneal
hymenial1645293hymenial
hymn12311313hy_mn_
hymnal1434913hy_mnal
hymned1535323hymned
hymns1337523hy_mns
hype125519813hype__
hyped145313333hype_d
hyper135213903hype_r
hypers144811913hypers
hypes135818673hype_s
hypha1637383hy_pha
hyphen1736393hyphen_
hyphens1836043hyphens
hyping15408483hyping
hyponea1546453hyponea
hyson1138693hyson_
hysons1237633hysons
hyte109018943hyte__
jnana12159043jna_na
kana85928523_ka_na
liana53915893lia_na
lycea10418943lyce_a
maenad939413_maenad
mana65341943_ma_na
manna75522533_manna
melena81110473melena
myna95815293my__na
nana46632893_na_na
novena936763novena
nyala836823nya_la
paean77222723_paean
plena75816393_plena
prajna1535073prajna
pyaemia1445733pyaemia
pyrene113210733pyrene
ruana5312423rua_na
sauna54117553_sauna
scena74815783_scena
syren85216743syren_
syrens94911993syrens
taenia6313193_taenia
varna84516173_varna
veena81912323_veena
vena76126293__vena
xylene1645793xylene
yamen104115183_yamen_
yamens114010823_yamens
yang85626063_ya_ng
yank115423663_ya_nk
yarn75230043_yarn_
yarns85621793_yarns
yawn106219093_yawn_
yawns114213273_yawns
yea66445753_y_e_a
yean75834583_yean_
yeans86624883_yeans
yen66847383_y_en_
yens75832263_y_ens
yenta83917043_y_enta

Search took 6 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.1401276364.3
2DLD Change Limit1127161515.06322262.7
3Display Results1511510.0463282.6
 (SQL Overall)1786911515.24934042.9
 
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.