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

128 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
moderne103712(None) 
modern939521modern_
moderner1145521moderner
modernes1138421modernes
moderns1037961moderns
codeine103815032codeine
moderate11710992moderate
modernest1248112modernest
modernise1244732modernise
modernize2144382modernize
modernly1443842modernly
borne77926793bo__rne
bourne83714093bo_urne
caserne93710063caserne
codein94916713codein_
codeina104010323codeina
codeines113114523codeines
codeins103715483codeins
coden86128543code_n_
codens94821013code_ns
coder86134213coder__
coderive1447683coderive
coders95426973coder_s
coerce10310403co_erce
cohere112716993coher_e
coterie9417393coterie
dene56643413__de_ne
dere56845903__der_e
doyenne1143883doyenne
eocene8311613eoce_ne
erne46727423___erne
eterne6311723_eterne
externe1438573externe
govern1036823govern_
governed1335193governed
governs1136103governs
indene73215373inde_ne
interne73218143interne
iodine74618643iod_ine
kerne94718213__kerne
lierne638023_lierne
loden66621143lode_n_
lodens74315063lode_ns
lucerne945753lucerne
maderize2049073maderize
madre85720173mad_r_e
madrone102812663madrone
merde84320123m__erde
mere67244443m__er_e
merge84523683m__erge
merle75824373m__erle
mesne75116293m__esne
midline102315103midline
miocene1147923mioce_ne
mode75840303mod___e
model84521693mode__l
modeled1139453modeled
modeler1039293modeler
modeling12311073modeling
modelled1236423modelled
modeller1136613modeller
models94216353mode_ls
modem103717143mode__m
modemed1336723modemed
modeming1437103modeming
modems114610763mode_ms
moderated1388143moderated
moderates12710743moderates
moderato1186263moderato
modernised1453403modernised
modernises1344733modernises
modernism1444003modernism
modernist1246263modernist
modernity1543533modernity
modernized2343733modernized
modernizer2243153modernizer
modernizes2244253modernizes
modernness1343523modernness
modes85537413mode__s
modest93818453mode_st
modester1197483modester
modesty13476983modesty
modiste1039283modiste
module93011033mod_ule
mofette1296773mofette
moidore1056153moidor_e
moire71017313mo_ir_e
molder93819273molder__
moldered1237173moldered
moldering1367853moldering
molders103315553molder_s
moline84422033mo_line
moment103319683mome_nt
moneran9311113moneran
monerans10310343monerans
montane91313623montane
moper94925923moper__
moperies12313873moperies
mopers104220373moper_s
mopery135210973moper_y
morae75831193mo__rae
moraine9314573moraine
mordent10313993morde_nt
more67154523mo__r_e
moreen8313343moreen_
moreens939963moreens
morelle91210803morelle
morn66237563mo__rn_
morns75527443mo__rns
morse76032703mo__rse
mourn77215013mo_urn_
mourned1037763mo_urned
mourner938083mo_urner
mourns84111013mo_urns
mover104220863mover__
movers115117193mover_s
mower104523453mower__
mowers113219403mower_s
mozette1886773mozette
murderee1146843murderee
odeon6411483_odeon_
odeons739023_odeons
oleine6313793_oleine
overnew13268133_overnew
rodent7519243rode_nt
someone938813someone
terne56426153__terne
vomerine1347683vomerine

Search took 8 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 Limit1340271287.58017681.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.78222962.1
 
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.