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

230 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
emerging123789(None) 
demerging1436641demerging
merging112711751_merging
remerging1358321remerging
amercing1337192amercing
deterging1237852deterging
embruing1344522embruing
emending12298892emending
emergent1149112emergent
everting122213132everting
exerting162211152exerting
immerging1544102immerging
reemerging1474582reemerging
serging93416672_serging
smerking15258462smerking
verging123812302_verging
abegging1334483abegging
alerting91312383alerting
amending12308913amending
avenging1345863avenging
averaging1446503averaging
averring12239063averring
averting122512733averting
barging114018483_barging
begging123012653_begging
bemeaning1436193bemeaning
bemiring13239603bemir_ing
berming123614823_berming
cementing1438763cementing
cering94522533_cer_ing
charging152910773charging
clerking15257163clerking
coercing1349003coercing
decerning1337293decerning
deferring1436143deferring
degerming1435753degerming
demarking1736763demarking
demeaning1337243demeaning
dementing13311043dementing
demergering1653593demergering
demeriting1448683demeriting
demurring1335253demurring
deperming1537113deperming
deserting11713143deserting
deserving1497903deserving
deterring1138623deterring
diverging15226693diverging
dredging12236423dredging
earing75235483e_ar_ing
earning83418213e_arning
earring83519013e_arring
edging93510713__edging
egesting1039013egesting
egging93210983__egging
ejecting18268163ejecting
electing112113783electing
emailing113010043emailing
embargoing1642423embargoing
embarking1844193embarking
embarring1444513embarring
embaying1635263embaying
embedding1643313embedding
embowing1636243embowing
embracing1645433embracing
embruting1444283embruting
emceeing1343573emceeing
emerge91510463emerg__e
emerged11158213emerg_ed
emergence14136613emergence
emergency17154553emergency
emergents1245973emergents
emerges101310883emerg_es
emeries91620023emer_ies
emerita938713emer_ita
emeriti949433emer_iti
emeroid101511173emeroi_d
emeroids11147713emeroids
emersion1047733emersion
emersions1147283emersions
emetin8613463eme_tin_
emetine9712943eme_tine
emetins9812643eme_tins
emitting112410353emitting
emoting10313563em_oting
empaling1338363empaling
emptying1634243emptying
encaging1258733encaging
energid948303energi_d
energids1045583energids
energies9310783energies
energise947333energise
energising1245233energising
energize1845563energize
energizing2145373energizing
engaging1147373engaging
engorging1244873engorging
enlarging1135803enlarging
enmeshing15114873enmeshing
enraging1049563enraging
enserfing1345893enserfing
entering91920053enter_ing
enuring8813883enur_ing
epergne1046143eperg_ne
erecting112415063erecting
erring73816473__erring
eserine7415903eser_ine
evening11310223eve_ning
experting1938053experting
exserting1736663exserting
eyeing10429363eye__ing
fevering152510083fever_ing
fledging14276523fledging
forging124114723_forging
gorging102611363_gorging
gurging102910113_gurging
hedging13348953_hedging
herding122915123_herding
herring113615873_herring
homering141512073homer_ing
imaging1138083im_aging
imbruing1344003imbruing
immersing1445123immersing
jeering153513043jeer_ing
jerking19308913_jerking
kedging14357553_kedging
kegging14328293_kegging
kerbing14308483_kerbing
kerfing15307533_kerfing
kerning124010893_kerning
leering83417643leer_ing
legging103912643_legging
leveraging1543793leveraging
levering122212503lever_ing
margin94016843_margin_
margins103815193_margins
marking144020123_marking
marling103322763_marling
marring103319543_marring
marting103325013_marting
meaning103918693_meaning
meeting103314963_meeting
melding113414273_melding
melling102822623_melling
melting103317753_melting
mending114018683_mending
mensing103915103_mensing
meouing1059203_meouing
meowing1368593_meowing
merino8315093_mer_ino
meriting11314673_meriting
merlin83916683_merlin_
merlins93015803_merlins
meshing134513813_meshing
messing103916393_messing
metering112915633meter_ing
meting94320593_me_ting
metring103215283_metring
mewing123914203_me_wing
mewling13329513_mewling
miring93723803_mir_ing
mogging123311493_mogging
morning103215043_morning
mugging122711793_mugging
muring95120373_mur_ing
nemertine1147073nemertine
nerving112910823_nerving
omening10310093ome_ning
overing111918053over_ing
parging113318603_parging
peering103520353peer_ing
pegging122811133_pegging
perking143716453_perking
perming123416083_perming
petering112516813peter_ing
piercing1346663piercing
pledging13276363pledging
purging113314183_purging
querying2135243querying
referring1338033referring
reforging1437663reforging
regorging1236823regorging
remarking1638883remarking
remedying1635143remedying
remeeting12311433remeeting
remelting12311703remelting
remending132311313remending
reneging102111533rene_ging
repegging1435593repegging
reperking1638703reperking
reserving131110643reserving
resurging1138613resurging
revenging1438083revenging
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
reverting132315133reverting
rezeroing1935933rezeroing
secerning1246203secerning
sergings10299203_sergings
sering74731813_ser_ing
serving113014983_serving
severing122013853sever_ing
sewering122411093sewer_ing
sieging92613203sie_ging
sledging11288183sledging
smarting113212453smarting
smearing113511753smearing
smeeking15317833smeeking
smelling113712723smelling
smelting11339713smelting
smirking15277233smirking
smudging13255723smudging
sparging122611133sparging
sterling93615553sterling
submerging1644583submerging
surging93115433_surging
swerving1546113swerving
tempering1438733temper_ing
terming104015993_terming
tiering8315243tier_ing
umbering1399433umber_ing
unerring9311273unerring
urging83413123__urging
veering113213683veer_ing
vegging13308873_vegging
venging123710943_venging
versing112314193_versing
wedging13308723_wedging
yerking15368803_yerking
zeroing1738343_zeroing

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622308.03018202.0
3Display Results2302300.0932473.1
 (SQL Overall)1786912308.29621539.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.