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 “prudent” 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
prudent1031043(None) 
ardent73022612ar_dent
credent10313972credent
crudest104510332crudest
erodent8313822erodent
imprudent1444612imprudent
pendent10314722pendent
precent113520262precent
present94022732present
prevent124016552prevent
proudest1138942proudest
prude84615972prude__
prudence1346332prudence
prudently1545532prudently
prudery1335242prudery
prudes94215442prude_s
prurient1048232prurient
purulent1047612purulent
rident7520192_rident
rodent7519242_rodent
rudest74016312_rudest
student848342student
trident8314192trident
argent74023663ar_gent
argument1158903argument
aridest8316143aridest
arpent84822093ar_pent
audient8312303_audient
brent75734133br__ent
brunet84419293brune_t
brunt75728753bru__nt
burden9412473burden_
burdens1039713burdens
cadent94120363_cadent
candent10417363candent
crude86018573crude__
crudely1336273crudely
cruder95612383crude_r
crudes96218623crude_s
cruet74831843cru_e_t
cruset84425093cruse_t
current9313693current
dent57158413___dent
eluent6315483elu_ent
erumpent1245453erumpent
evident1139993evident
fluent9313933flu_ent
frumenty1644573frumenty
gradient10310373gradient
grunt65523543gru__nt
impudent1346283impudent
indent73021243_indent
louden73711793louden_
loudens8368053loudens
loudest839933loudest
lucent8313823_lucent
mordent10313993mordent
nudest74113833_nudest
opulent938833opulent
orient6322533or_ient
pandect12310953pandect
parament12415403parament
parent83230423p_arent
patent84524923p_atent
patient9617073patient
patulent1048603patulent
payment14310703payment
pedant9319493p_edant
pendant10314853pendant
pendents1139413pendents
pent66559073p___ent
percent113520603percent
perpent112318813perpent
pigment12510733pigment
ponent82821593p_onent
portent93619643portent
potent84223353p_otent
prebend12319443prebend
precedent1448873precedent
precents123015043precents
precept133112513precept
predeath1447003predeath
predict12315323predict
preedit10512463preedit
preen75925053pr_een_
preens85020113pr_eens
prefect141011073prefect
preheat12413893preheat
prelect111013833prelect
premeet11615153premeet
premen105017803premen_
presents103315643presents
preset84430983prese_t
president12410993president
prest75736353pr__est
pretend104011013pretend
pretest9517633pretest
pretext1639663pretext
prevents133012293prevents
pride84724743pride__
prided103618033pride_d
prides94324183pride_s
priding113317543priding
priest84125423pr_iest
print74837463pr__int
privet113821343prive_t
product1279233product
progeny1389463progeny
project1838453project
projet15315183proje_t
propend123311273propend
propene112716043propene
prosect11313393prosect
protect11313633protect
protend104012793protend
protest9317533protest
prouder10310383proude_r
proven114314773proven_
provident1546223provident
prowest12311533prowest
prudences1446683prudences
prudential1375123prudential
prudish1376563prudish
prune75119633pru__ne
pruned93413113prune_d
pruner83413453prune_r
pruners93710723pruners
prunes83419063prune_s
pruning10311733pruning
prutot8311823pru_tot
pschent1437413pschent
pudency1544763p_udency
pudenda1142963p_udenda
pungent10311233pungent
punnet83518843p_unnet
punt65747203p_u__nt
purest84021933p_urest
recent83630853_recent
redeny102712733_redeny
regent74127673_regent
relent64431853_relent
rent46661243_r__ent
repent84728873_repent
rerent63832453_rerent
resent63833623_resent
rodents8611543_rodents
rude55632793_rude__
rudely10389973_rudely
ruder65320543_rude_r
rudery10419033_rudery
rudiment1147663_rudiment
rumen74419503_rumen_
rumens83611813_rumens
runt46647993_ru__nt
sprent84522383spr__ent
sprucest12295783sprucest
strident9310173strident
students954683students
tridents938583tridents
truant6315783tru_ant
trudgen9357053trudgen_
trudgens10255153trudgens
truest64816193tru_est
turgent8712393turgent
urgent73816043ur_gent
virulent1146433virulent

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.403443402.0
2DLD Change Limit1340271667.08018930.4
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.54623680.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.