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

104 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
elytra93489(None) 
elytron1045462elytron
elytrum1243562elytrum
extra1239002e_xtra
eyra76217552e_y_ra
flytrap1543252flytrap
lycra10317972_lycra
lytta888062_lytta
ultra539362ul_tra
adyta936853adyt_a
altar55520643al_tar
antra56521923_antra
calyptra1542963calyptra
centra84113883centra
contra83314703contra
delta66117773del_t_a
elate55335883elat_e
elated74725823elated
elater64724203elater
elaters74420193elaters
elates65032363elates
elder64020023elder_
elders74817303elders
electro92810033electro
elite56230183elit_e
elites66027123elites
elodea738673elodea
elute54822573elut_e
eluted74915263eluted
elutes64020313elutes
eluvia936133eluvia
elver85216243elver_
elvers93814983elvers
elysian1065083elysian
elytroid1244963elytroid
elytrous1145503elytrous
entera64216833entera
entia5318203e_ntia
entrap8710563e_ntrap
entry82414263e_ntry
era35741503e___ra
estral64716513e_stral
estray95713333e_stray
eta35834193e__t_a
etna46415263e__tna
etyma1036583ety_ma
exedra1434503exedra
extras13310223e_xtras
eyer76127283e_yer_
eyers86521333e_yers
eyras84715923e_y_ras
eyre75525253e_y_re
eyry106315883e_y_ry
flora85317103fl_ora
flota85315643flot_a
flyer114916253flyer_
flyers125712803flyers
flyte115713943flyt_e
flyted13378773flyted
flytes123911563flytes
flytraps1642963flytraps
helotry1345653helotry
hemelytra1751383hemelytra
hydra12249223_hydra
kalyptra1751433kalyptra
labra75415463_labra
latria62313593_latria
laura54116203_laura
lepta75714393lept_a
libra74712423_libra
lira46928683_l_ira
litre55421463_litre
lota47233503_lot_a
lustra6358893lustra
lutea54819073_lutea
lyard95113213_lyard
lyart85121883_lyart
lycea10418943_lycea
lycras11287253_lycras
lyre75623793_ly_re
lyssa835713_lyssa
lytic104513033_lytic
lyttae994713_lyttae
lyttas985073_lyttas
mantra84116093mantra
olestra746173olestra
osetra667423osetra
pelota8612833pelot_a
peltry11288653pel_try
peytral1287503peytral
plectra1145783plectra
pleura837533pleura
plyer106214333plyer_
plyers114912983plyers
rhyta1135083rhyt_a
ristra6310713ristra
rostra6310933rostra
sistra639333sistra
slyer85515123slyer_
sutra54217933_sutra
tantra63713353tantra
tetra53417953_tetra
ultras6310193ul_tras
yantra9449623yantra

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.390458182.1
2DLD Change Limit1127161044.73323814.9
3Display Results1041040.0333151.5
 (SQL Overall)1786911045.15634656.9
 
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.