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

258 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
niteries831838(None) 
niterie7313741niterie_
arteries8321482arteries
coteries10422702coteries
eateries8324312eateries
fineries112416742fineries
interims101013072interims
internes82721232internes
interties9320332interties
liveries11314372liveries
miseries10320402miseries
naperies10313902naperies
niceties10310862niceties
nineties8312912nineties
nitchies1339072nitchies
niters64624212niter__s
nitres65519332nit_r_es
nitrides92910702nit_rides
nitrids8269632nit_rids
nitriles8269922nit_riles
nitrils72810702nit_rils
nitrites82313452nit_rites
notaries8314932notaries
pineries102419082pineries
vineries112716042vineries
wineries112316532wineries
aeries64737783__aeries
amberies122514683amberies
aperies9423203_aperies
asterias8317013asterias
bakeries14312193bakeries
batteries11615113batteries
bibberies1297133bibberies
binaries10314183binaries
binderies12311683binderies
bitcheries1745903bitcheries
biters83925243biter__s
boiseries11411043boiseries
booteries11312773booteries
boweries13312293boweries
briberies1348333briberies
butleries11710073butleries
butteries11711763butteries
catteries11815523catteries
cauteries11615393cauteries
celeries10316313celeries
cicelies1269753cicelies
cinerins10414103cinerins
citers85022983citer__s
cities84524853cit__ies
citifies13310683citifies
citrines102513133cit_rines
citrins92614363cit_rins
coterie9417403coterie_
cutleries1179213cutleries
dataries9314033dataries
deterges101510093deterges
diaries83321953di_aries
dietaries10410663dietaries
dimerizes2167943dimerizes
dioecies1138933dioecies
ditties83116983dit_ties
diverges13258313diverges
doweries12411933doweries
duperies11312813duperies
emeries91620023_emeries
emperies12314563emperies
engineries1145473engineries
enterics10312853enterics
entries71523163ent_ries
externes1539833externes
faeries104118993_faeries
fakeries1559833fakeries
fiberizes2346173fiberizes
fierier103511193fi_erier
fieriest112112243fi_eriest
fisheries1548643fisheries
histories12412473histories
icterics1247053icterics
inheres10315173inher_es
inherits11310103inherits
injuries1567683injuries
innerves1158013innerves
interbed112413103interbed
interbeds12238903interbeds
interest8319183inter_est
interfiles1349993interfiles
interim9912873interi_m
interior8513093interior
interiors9513563interiors
interlines101116453interlines
intermesh1446703intermesh
intermits111212203intermits
intermixes1948393intermixes
interne73218153interne_
interned93016653interned
internee82718523internee
internees93014843internees
interns73116773inter_ns
interred92615263interred
interrex15249823interrex
inters64328053inter__s
intersex15209733intersex
intertie8317613intertie_
interview1547363interview
interviews1645263interviews
inverses112410983inverses
itemise997453_itemise
itemises1087693_itemises
itemizes19106023_itemizes
iterates81317823_iterates
ivories10310713_ivories
japeries17311463japeries
jitterier1644433jitterier
jitteriest1744553jitteriest
joineries1648103joineries
kiters105218593kiter__s
kitties113213623kit_ties
knaveries1645013knaveries
laterites9715053laterites
laterizes18513013laterizes
liberties1149203liberties
lienteries1047563lienteries
liernes739623li_ernes
lingeries10511813lingeries
listerias959233listerias
litanies8310993litanies
literacies1248803literacies
literals8312293literals
literates91415653literates
liters65429883liter__s
litres65220393lit_r_es
liturgies1043483liturgies
liveried1238733liveried
lotteries9311073lotteries
masteries111018493masteries
materiel10311253materiel
materiels1147833materiels
miniseries1246753miniseries
mitered103213233miter_ed
miterer92511333miter_er
miterers10219683miterers
mitering113015403mitering
miters84328783miter__s
mitres83922073mit_r_es
monitories1248893monitories
moperies12313873moperies
mysteries141211193mysteries
naiveties1245433naiveties
natures7311963natur_es
nectaries1149813nectaries
neotenies948383neotenies
neoterics1145693neoterics
nereis6315343n__ereis
nerves94216193n__erves
newies91014073n__ewies
nidering10510483nidering
niderings1175403niderings
nidifies1238233nidifies
nieces84112713ni_e_ces
nieves94311293ni_e_ves
nifties102612503ni_fties
nighties121011383nighties
nimieties1145223nimieties
ninepins1045873ninepins
ninnies73713613ni_nnies
niseis63512023nise_i_s
nitchie1247233nitchie_
niter55028973niter___
nitery94412173niter__y
nites55736343nit___es
nitrates82516223nitrates
nitre57519683nit_r_e_
nitric82512063nit_ri_c
nitrid72812233nit_ri_d
nitride82811243nit_ride
nitrided10276753nit_rided
nitrifies12107923nitrifies
nitrify1335793nit_rify
nitril62511533nit_ri_l
nitrile73011373nit_rile
nitrite72314463nit_rite
nitros64214123nit_r_os
nitrous73512483nit_rous
nittier73512243nit_tier
nittiest82712603nit_tiest
nitwits1035053nit_wits
nixies135313873ni__xies
notarizes1848713notarizes
noters64021003noter__s
notifies11310423notifies
numerics1266283numerics
nunneries947113nunneries
nurseries948013nurseries
nutrias739813nut_rias
orreries8310123orreries
outcries10313573outcries
peeries93623023_peeries
pierces113411193pi_erces
pieties9419223pi_eties
piggeries13107893piggeries
piperines131610693piperines
pities83828083pit__ies
poetries10315583poetries
poperies12316793poperies
potteries11313593potteries
printeries12410633printeries
pterins9812993_pterins
queries16315873_queries
retries74129073ret_ries
reveries112518513reveries
rifleries1247683rifleries
roperies10315763roperies
roseries8317313roseries
rotaries8315693rotaries
ruderies9311333ruderies
sanitaries1049913sanitaries
series64540973__series
siderites10410433siderites
smitheries1546053smitheries
spiceries1349313spiceries
steres63929533_ster_es
stories7324273_stories
terces83921413__terces
ternes65422903__ternes
terries73425633__terries
tiderips1145383tiderips
tierces93710453ti_erces
titers64526413titer__s
titres64718933tit_r_es
titties73617363tit_ties
tories65435883__tories
tries55742813__t_ries
uniters73814173uniter__s
unities72520153unit__ies
universes1245423universes
vanitories1346903vanitories
veeries102916893_veeries
veneries112815033veneries
victories1448913victories
vitesses1136333vitesses
vitrics12198553vit_rics
vitrines112610913vit_rines
vivaries1439263vivaries
voleries11313233voleries
votaries11312013votaries
wasteries121115343wasteries
waterier11312083waterier
wateriest12312233wateriest
wienies102213683wi_enies
wiggeries14136573wiggeries
winterier1238333winterier
winteriest1348813winteriest
winterizes2247143winterizes
wisterias1248103wisterias
witcheries1845463witcheries
witherites1645973witherites
withies133913543wit_hies

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622586.62622058.9
3Display Results2582580.1062434.0
 (SQL Overall)1786912587.16824929.0
 
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.