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

178 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
nineties831292(None) 
niceties10310861niceties
dinettes9310192dinettes
fineries112416752fineries
kinetics14207252kinetics
kinetins12228152kinetins
naiveties1245432naiveties
nifties102612502ni_fties
nighties121011382nighties
nimieties1145232nimieties
ninepins1045872ninepins
nineteen844152nineteen
nineteens943772nineteens
ninetieth1253372ninetieth
ninetieths1351752ninetieths
ninnies73713612nin_nies
niteries8318382niteries
pieties9419222pi_eties
pineries102419082pineries
vineries112716042vineries
wineries112316532wineries
aminities11312913aminities
amnesties1166873amnesties
anilities9516003anilities
anisettes946673anisettes
anxieties1646263anxieties
aunties73920073aun_ties
banties94324763ban_ties
binaries10314183binaries
binderies12311693binderies
caninities12410493caninities
canities101519263canities
cicelies1269753cicelies
cineoles10109403cineoles
cinerins10414103cinerins
cities84524853ci__ties
dainties9312403dain_ties
dignities1149593dignities
dimities11314003dimities
dinette8310013dinette_
dinghies1347363dinghies
dingies93618243din_gies
dinkies123716033din_kies
dioecies1138933dioecies
dirties83119383di_rties
ditties83116983di_tties
eighties12710803eighties
enemies9313693_enemies
engineries1145473engineries
entireties1047273entireties
fifties132111083fi_fties
finesses111912343finesses
finites10315923finit_es
fixities1838223fixities
gaieties9310183gaieties
gayeties1236883gayeties
genetics11128613genetics
genettes938303genettes
gingelies11277503gingelies
hinnies103615113hin_nies
honesties1249913honesties
inanities9312443inanities
incites93218483_incites
indies73822783_in_dies
indites83618983_indites
inertias8410383_inertias
infinities1369453infinities
innerves1158013innerves
instils7811453_instils
interties9320343interties
intines7921113_in_tines
intis55121643_in_ti_s
invites103915813_invites
joineries1648103joineries
kilties113014143ki_lties
kineses113111253kine_ses
kinesics14286283kinesics
kinesis11259593kinesi_s
kinetic13209173kineti_c
kinetin11248263kineti_n
kitties113213623ki_tties
lenities8315943lenities
liberties1149213liberties
lifetimes1444153lifetimes
lindies8416583lin_dies
lineages979183lineages
lingeries10511813lingeries
lintier73613803lin_tier
lintiest82715913lin_tiest
liveries11314373liveries
lunettes836753lunettes
mimetites1346823mimetites
minifies13312903minifies
minnies93617363min_nies
mintier93615993min_tier
mintiest103217143min_tiest
minutes93513443minut_es
miseries10320403miseries
moieties10311263moieties
monetise10311473monetise
monetises11311043monetises
monetizes2049263monetizes
naivetes1145113naivet_es
nancies93516843nan_cies
nannies73015203nan_nies
naperies10313903naperies
nasties73520493n_asties
navettes1136613navettes
neckties1445913neckties
newies91014073__newies
nicotines1148353nicotines
nicotins1058173nicotins
nidates8311893nidat_es
nidifies1238233nidifies
nieces84112713ni_e_ces
nieves94311293ni_e_ves
niftier10328713ni_ftier
niftiest112910073ni_ftiest
nightie1179653nightie_
ninepin945573ninepi_n
nines55937343nin___es
ninety9510963ninet__y
ninths936933nin_t_hs
niobites1037313niobites
niseis63512023nise_i_s
nitchies1339073nitchies
niterie7313743niterie_
nites55736343ni__t_es
nitres65519333ni__tres
nitrites82313453nitrites
nittier73512243ni_ttier
nittiest82712603ni_ttiest
nixies135313873ni__xies
noisettes946533noisettes
nonentries1048283nonentries
nonets64118703nonet__s
novelties1245993novelties
nudities939683nudities
nunneries947113nunneries
panties94230933pan_ties
pigsties1139783pigsties
pinenes93416693pine_nes
pinites9319533pinit_es
pinkies133818263pin_kies
pinnies93318443pin_nies
pintles94118733pin_tles
pintoes95117713pin_toes
pipettes1237563pipettes
pities83828083pi__ties
plenties10314693plenties
punties94520783pun_ties
reties65436193__reties
righties12711573righties
safeties1139163safeties
sanities81219773sanities
sienites8311913sienites
sixties14310973si_xties
sureties8316583sureties
sweeties11159723sweeties
tineids8337873tine_ids
titties73617363ti_tties
tonetics1048943tonetics
tonettes839203tonettes
trinities9313353trinities
twenties1137503twenties
ubieties1046923ubieties
unities72520153_unities
unties64326923_un_ties
vanities111414493vanities
veneries112815033veneries
videttes1266333videttes
vignettes1344673vignettes
vinifies1439873vinifies
wienies102213683wi_enies
wingtips1443253wingtips
wintles103414983win_tles
zincites1946633zincites
zonetimes2044203zonetimes

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.436409841.7
2DLD Change Limit1461621787.93618417.6
3Display Results1781780.0802225.0
 (SQL Overall)1786911788.45221141.9
 
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.