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

103 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
emerita93871(None) 
emeritae1046351emeritae
emeritas1046431emeritas
emeriti949431emeriti
amrita8411132am_rita
demerit10314992demerit_
demerits11310762demerits
emeries91620022emeries
emeritus1045172emeritus
feterita1166462feterita
merit7339182_merit_
merits8320872_merits
temerity1346902temerity
amanita9310453amanita
amberina1247393amberina
amenity1238333amenity
amentia9310153amentia
amreeta945163amreeta
amritas939093am_ritas
celerity1347643celerity
cementa112810533ceme_nta
ceria75125353_ceri_a
cerite84724873_cerite
dementia1157823dementia
demerara1144853demerara
demerited1339073demerited
edemata1046003edemata
eerie55228533e_eri_e
eerier64320023e_erier
eerily92913563e_erily
egesta7428653ege_sta
ejecta15337393eje_cta
elegit71212893elegit_
elegits8149343elegits
embrute1145703embrute
emeerate10410103emeerate
emerald1046923emerald
emerge91510463emer_ge
emerged11158213emerged
emerges101310883emerges
emerging1237893emerging
emerod9139213emer_od
emerods10137653emerods
emeroid101511183emeroid
emeroids11147723emeroids
emersed10138513emersed
emersion1047733emersion
emery104814333emer__y
emesis84712623emesi_s
emetic10614453emeti_c
emetics11610723emetics
emetin8613463emeti_n
emetine9712943emetine
emetins9812643emetins
emeute838533eme_ute
emirate91015833emirate
emit65438423em__it_
emits75421473em__its
emperies12314563emperies
emporia1148753empori_a
emprise11310723emprise
emprize2038843emprize
enemata948013enemata
eremite9312833eremite
erica7316543__erica
errata639013e_rrata
eserine7415903eserine
esprit8312843esprit_
esprits938393esprits
eternity1146683eternity
eucrite939903eucrite
evert84929513ever_t_
everts94514893ever_ts
excreta1674623excreta
exert124624143exer_t_
exerts133712293exer_ts
feria85922713_feri_a
ferity122813343_ferity
feteritas1264893feteritas
imperia1148423imperi_a
inedita846793inedita
inertia7410203inertia
legerity1245713legerity
maria75032883_mari_a
marina84623413_marina
marital92314183_marital
media84721713_medi_a
medina94114093_medina
meerkat1346943meerkat
menta74424423_me_nta
merino8315093_merino
merited10313853_merited
meta65932413_me__ta
myrica1336833_myrica
omenta83411723ome_nta
periti8319953_periti
querida1744353querida
senorita848283senorita
severity1446973severity
veritas103012753_veritas
verite94323443_verite
verity123714853_verity
yperite1249893yperite

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.440406115.9
2DLD Change Limit1340271036.17021722.4
3Display Results1031030.0303433.3
 (SQL Overall)1786911036.64026911.3
 
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.