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

110 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
hyaenas133498(None) 
hyaena1235361hyaena_
hyenas1288951hy_enas
faenas94412762_faenas
hyaenic1545992hyaenic
hyena11810252hy_ena_
hymenal1545182hymenal
hymens1437992hymen_s
anas46649863__a_nas
annas55824883__annas
arenas65021993_arenas
asanas6514113asa_nas
bwanas1157443bwa_nas
cannas84518403_cannas
catenas9313103catenas
cyans105714813cya_n_s
cymenes1477413cymenes
dharnas1155373dharnas
dracenas1145793dracenas
faena85014203_faena_
faunas94013633_faunas
fraena938063fraena_
galenas83310333galenas
goannas836223goannas
gyrenes11267523gyrenes
haemal113811643h_aemal
haems105517013h_ae_ms
haen76229453h_aen__
haeres94017033h_aeres
haes77651023h_ae__s
haets86525123h_ae_ts
hahas117118443h_a_has
haints94417583h_aints
halmas117017893h_almas
halvas124714173h_alvas
hamzas20119013h_amzas
hands95327383h_a_nds
hangs95726723h_a_ngs
hanks126226863h_a_nks
hansa85416783h_a_nsa
hansas94616043h_ansas
hants86335403h_a_nts
haunts95614393h_aunts
havens124514043haven_s
hayers124415943haye_rs
hayings14379393hayings
hazans183411653h_azans
headends13326723headends
heavens13439303heaven_s
hennas94211803h_ennas
hens75642573h__en_s
hents87330743h__ents
hetaeras1146723hetaeras
hosannas1143603hosannas
hoydens14347403hoyden_s
hryvnas1641493hryvnas
hyalines14169323hyalines
hyalins13229273hyalins
hydras13239313hy_dras
hyenic1438723hy_enic
hyetal1236543hy_etal
hygienes1543413hygienes
hylas114815903hy__las
hymen13311043hymen__
hymeneal1643473hymeneal
hymeneals1742533hymeneals
hymenia1546393hymenia
hymenial1645293hymenial
hymnal1434913hy_mnal
hymnals1543523hy_mnals
hymns1337523hy_mn_s
hypers144811913hype_rs
hypes135818673hype__s
hyphens1836043hyphen_s
hyponeas1646383hyponeas
hysons1237633hyson_s
jnanas13207303jna_nas
kanas95326913_ka_nas
lianas63713383lia_nas
maenad939413_maenad
maenads1037373_maenads
manas76240423_ma_nas
mannas85019803_mannas
melenas999203melenas
mynas105815233my__nas
nanas55928633_na_nas
novenas1036893novenas
nyalas936903nya_las
paeans85118263_paeans
prajnas1635453prajnas
pyaemias1545063pyaemias
pyrenes123511223pyrenes
ruanas6311263rua_nas
saunas63915433_saunas
scenas84114703_scenas
syrens94911993syren_s
taenias7311283_taenias
varnas94212823_varnas
veenas91410413_veenas
whenas124610463_whenas
xylenes1745093xylenes
yamens114010823_yamen_s
yangs95618693_ya_ngs
yanks125316573_ya_nks
yarns85621793_yarn_s
yawns114213273_yawn_s
yeans86624883_yean_s
yeas78638423_y_e_as
yens75832263_y_en_s
yentas94614213_y_entas

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271106.67320085.0
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.87525991.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.