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

166 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
erodent831382(None) 
rodent7519241_rodent
ardent73022612ar_dent
credent10313972credent
erode64520992erode__
eroded84313582erode_d
erodes74819882erode_s
eroding9314272eroding
evident1139992evident
mordent10313992mordent
prudent10310432prudent
rident7520192_rident
rodents8611542_rodents
trident8314192trident
acrodont1148123acrodont
aeroduct1155633aeroduct
aerodyne1244193aerodyne
argent74023663ar_gent
aridest8316143aridest
aroint6328153aro_int
aroynt9312893aro_ynt
arpent84822093ar_pent
brent75734133br__ent
broaden10289143broaden_
broadens11267243broadens
broadest1138573broadest
broken124011523broken_
cadent94120363_cadent
candent10417363candent
cerement12315133cerement
cholent12313253cholent
coden86128543_coden_
codens94821013_codens
cogent9321003_cogent
creodont1147693creodont
crownet123714113crownet
crudest104510333crudest
decadent1249003decadent
decedent12310213decedent
dent57158413___dent
deponent11410553deponent
docent92918683_docent
duodena943453duodena
eldest72912683e_ldest
element9317803element
elodea738673elode_a
elodeas836963elodeas
eloquent1745003eloquent
eluent6315483e_luent
eminent9313853eminent
emodin9310353emodin_
emodins1039433emodins
enrolment1148473enrolment
eocene8311613e_ocene
epode85114093epode__
epodes94315563epode_s
erect74129333er__ect
erogenic111110543erogenic
erose55727273erose__
erosely1038083erosely
eroses65327053erose_s
errant6618733er_rant
erumpent1245453erumpent
event85924443e__vent
exigent1539513exigent
exoderm1754893exoderm
exogen1436513exogen_
exogens1536883exogens
exponent1747133exponent
extent132714913e_xtent
ferment12315573fer_ment
fervent13310063fer_vent
foment113718303_foment
fornent10312933fornent
forwent13310533forwent
fromenty1645243fromenty
front85029223fro__nt
frozen18408443frozen_
gerent73223103ger__ent
godet7530043_gode_t
gradient10310373gradient
grodiest10310553grodiest
horrent10313553horrent
indent73021243_indent
kerogen1236093kerogen_
kerogens1345763kerogens
kerosene1254823kerosene
kronen10348913kronen_
loden66621143_loden_
lodens74315063_lodens
loment84021473_loment
modest93818453_modest
moment103319683_moment
mordant10312403mordant
mordents1138813mordents
nocent83217413_nocent
oreodont947603oreodont
orient6322533or_ient
orogeny11107023orogeny
pendent10314723pendent
percent113520603per_cent
perpent112318813per_pent
ponent82821593_ponent
portent93619643portent
potent84223353_potent
precent113520263precent
present94022733present
prevent124016553prevent
product1279233product
progeny1389463progeny
project1838453project
projet15315183proje_t
propend123311273propend
propene112716043propene
prosect11313393prosect
protect11313633protect
protend104012793protend
protest9317533protest
proudest1138943proudest
proven114314773proven_
provident1546223provident
prowest12311533prowest
reagent8716603reagent
reblent9614253reblent
recent83630853_recent
redden83613623redden_
reddens9259783reddens
reddest9311953reddest
redeny102712733_redeny
redolent9411883redolent
regent74127673_regent
relent64431853_relent
rent46661243_r__ent
reopen8311573reopen_
reopens939373reopens
reorient8613473reorient
repent84728873_repent
rerent63832453_rerent
resent63833623_resent
resident9313753resident
rode55844303_rode__
rodeo65921093_rode_o
rodeos75314503_rodeos
rodes614039083_rode_s
rodmen939713_rodmen_
roset55945243_rose_t
rouen54920903_rouen_
rouens64814443_rouens
roven85521973_roven_
rowen84921153_rowen_
rowens94515303_rowens
rudest74016313_rudest
serpent92916283ser_pent
sorbent92915243sorbent
strident9310173strident
student848343student
torment9316173torment
torrent7313413torrent
tridents938583tridents
trodden934883trodden_
trode65322853trode__
urgent73816043ur_gent
urodele845963urodele
verdant11313293ver_dant
violent102110813violent
wooden103610303wooden_

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.393454684.5
2DLD Change Limit1340271666.78019768.0
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.23624694.7
 
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.