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

134 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
nurture73664(None) 
nurtured935251nurtured
nurturer844471nurturer
nurtures837441nurtures
culture939392culture
future939562fu_ture
multure939182multure
nature6311262n_ature
nervure1034972nervure
nurtural845492nurtural
nurturers943352nurturers
purpure1195992purpure
rupture966162rupture
suture6313202su_ture
torture738592torture
vulture1036762vulture
aperture1046383aperture
armure8710133_armure
austere7312993austere
bordure1035783bordure
capture1138913capture
cloture9238453cloture
couture9310623couture
cubature1244693cubature
cultured1137233cultured
cultures10310153cultures
curare84916953cur_are
curtate9312643curtate
curter85320083curter_
curule83614123cur_ule
curvature1442793curvature
denture8311893denture
ductule1065503ductule
facture12108933facture
feature1039853feature
fixture1734963fixture
fortune1068303fortune
furfur1235553furfur_
furfures1445663furfures
furniture1242643furniture
furore9410013fur_ore
further1337003further
furtive1337173furtive
futures10310263fu_tures
gesture839243gesture
guipure1043533guipure
humiture1344123humiture
hurter93915853hurter_
hurters103413643hurters
hurtle93512943hurt_le
juncture1743903juncture
kultur1034433kultur_
kulturs1134723kulturs
lecture9149523lecture
lustre64011683lust_re
mature8313473_mature
mixture1635413mixture
multures1039333multures
murmur1034853murmur_
murmured1343113murmured
murmurer1242873murmurer
murmurs1134523murmurs
murre74821073mur__re
murther1237953murther
mutule8311423mu_tule
natured838963n_atured
natures7311963n_atures
nervature1263823nervature
nervule1044943nervule
nervures1135123nervures
nitre57519683n_it_re
noctule936083noctule
nocturn944653nocturn
nocturne1043393nocturne
norther1039733norther
nurse54420123nur__se
nurser64314503nurser_
nursers74311833nursers
nursery10396023nursery
nurturance1252533nurturance
nurturant964853nurturant
nurturing1045013nurturing
nutate63017373nu_tate
nutter63918053nutter_
nutters74215433nutters
nuttier73112023nuttier
ordure756813_ordure
outre53922203ou_t_re
outturn737123outturn
overture111511683overture
parure8312523par_ure
pasture9311463pasture
perdure10379623perdure
perjure16327963perjure
perturb1146003perturb
picture1158613picture
posture9313253posture
puncture1245053puncture
purpura1144793purpura
purpures1276143purpures
pursue84512253pursu_e
pursuer9338893pursuer
purtier93214093purtier
pustule937683pustule
quatre153512353quat_re
rapture937393rapture
ruptured1144683ruptured
ruptures1056683ruptures
stature74410683stature
sutured8310373su_tured
sutures7314223su_tures
tartare73012683tartare
tartufe1064673tartufe
texture1497083texture
tortured935843tortured
torturer835493torturer
tortures838913tortures
turtle63213573turt_le
turtler72610323turtler
unpure82911533_unpure
unretire846963unretire
unsure62815413_unsure
untrue6310773untru_e
untruer737113untruer
untune62511603_untune
uptore8279453_uptore
upturn8286243_upturn
urare56322553_ur_are
venture10311173venture
verdure11287773verdure
vesture10310373vesture
virtue9358673virtu_e
vultures1137213vultures
wafture1334853wafture

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.406440125.6
2DLD Change Limit1340271347.03019065.0
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.49923828.6
 
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.