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

187 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
elapids103650(None) 
elapid939541elapid_
elains64919852ela_ins
elands74914772ela_nds
elapine9310672elapine
elapses957662elapses
lapides103012042_lapides
lapins84520682_lapins
lapis76223152_lapi_s
lipids94310922_lipids
plaids94312442pla_ids
rapids94913892_rapids
salpids1038192salpids
acarids105312243acarids
acids87121003__acids
agamids11317013agamids
aids57846363__a_ids
alands75418373ala_nds
alanins7315803alanins
alcids94812293al_cids
alipeds10386793alipeds
amids85627513__amids
aphids125110843__aphids
apods86316343__apods
aramids102810513aramids
beladies11310423beladies
belauds1036643bela_uds
blains84516373bla_ins
braids95015693bra_ids
caids85226423_ca_ids
canids95118133_canids
capias10318353_capias
capsids1239333_capsids
clads85722733cla__ds
claims105211573cla_ims
claps95626183clap__s
claries93422203claries
clerids1049093clerids
clupeids1343243clupeids
cupids11369193_cupids
cuspids12427113cuspids
cyanids13297933cyanids
decapods1444623decapods
deltoids1045483deltoids
diacids1137863diacids
diapirs10347643diapirs
diapsids1244753diapsids
easies64126633e_asies
eclairs935963ecla_irs
egads74610923ega__ds
elain55324703ela_i_n
eland65820393ela_nd_
elans55527753ela__ns
elaphine1346113elaphine
elapse857523elap_se
elapsed1056103elapsed
elapsing1146713elapsing
elastics102710883elastics
elastins82111743elastins
elated74725823elated_
elaterids1046163elaterids
elaters74420193elaters
elates65032363ela_tes
elating83423083elating
elation73620453elation
elations83719123elations
elative10312453elative
elatives1139783elatives
elds56324853el___ds
elegies81312903elegies
elegits8149343elegits
elemis8312383elemi_s
elfins94810943el_fins
elicits9311233elicits
elide64922643el__ide
elides74420693el__ides
elixirs1443543elixirs
eloins65419383el_oins
eloped95914143eloped_
elopers95112943elopers
elopes85918163elop_es
eloping103512833eloping
emails84412343ema_ils
epics95014283e__pics
equids16439143e_quids
espies83716803e_spies
etamins91511833etamins
etapes85415293etap_es
expands17195733expands
eyelids1135943eyelids
felids103111623fel__ids
flails94313003fla_ils
flairs95711913fla_irs
flaps105621383flap__s
flavins1338543flavins
fleapits1363253fleapits
fluids10349423fl_uids
gadids95611823_gadids
gelatins93414093gelatins
gelatis83313513gelati_s
glacis94012133glaci_s
glads75620613gla__ds
glairs75211333gla_irs
glands85314403gla_nds
halids104016133_halids
haloids113012553haloids
helipads1443873helipads
hexapods2143403hexapods
jalapins1745623jalapins
keloids1288663kel_oids
kelpies13289903kel_pies
ladies75124883_ladies
lads56549133_la__ds
laics76419253_la_ics
laid56439143_la_id_
lairds74711613_lairds
lairs55425873_la_irs
lameds94812033_lameds
lamias85020613_lamias
lampads12477623_lampads
lands65426903_la_nds
lapels83712043_lapels
lapidist1147833_lapidist
lapin75222923_lapi_n
lapises93513463_lapises
laps66848873_lap__s
lapses85217693_lapses
lapsus8437273_lapsus
lards65331863_la_rds
laris54737463_lari_s
lauds65618483_la_uds
layins93817653_layins
lazies154418783_lazies
leads66028493lea__ds
leaped94317773leaped_
leapers93716663leapers
leaping103215993leaping
leaps75522933leap__s
lids56336463_l__ids
lipid85916173_lipid_
lipide93511063_lipide
lipides103810623_lipides
lipins85016883_lipins
lipoids1038233_lipoids
loids66220703_l_oids
lupins84514463_lupins
maids86327143_ma_ids
megapods1444903megapods
melanics1237733melanics
melanins10310383melanins
melanoids1245553melanoids
meloids10911453mel_oids
okapis1235393okapi_s
ozalids1794063ozalids
pelagics1345553pelagics
peracids13310073peracids
placid114012543placid_
placoids1347343placoids
plaid85118303pla_id_
plains85019593pla_ins
plaits83816473pla_its
plasmids13236553plasmids
plastids11269213plastids
platies93722543platies
qaids156116313_qa_ids
raids65827513_ra_ids
ranids75118703_ranids
rapid86422033_rapid_
relaid75518443rela_id_
relands85214883rela_nds
relapses1038033relapses
relaxins15248683relaxins
saids65328853_sa_ids
salpid9510883salpid_
sapid84720933_sapid_
sayids104310973_sayids
sialids839723sialids
slaps76025713slap__s
sloids73712693sl_oids
sparids103512123sparids
stupids1035273stupids
tapirs84113173_tapirs
tapis75028863_tapi_s
tilapias1045293tilapias
torpids1037373torpids
vapid115614283_vapid_
vespids1334613vespids

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.456391866.2
2DLD Change Limit1340271876.14021828.5
3Display Results1871870.0603116.7
 (SQL Overall)1786911876.65626846.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.