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

191 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
juniper163402(None) 
junipers1733931junipers
juicer1536282ju_icer
jumper173612372ju_mper
jumpier18317942jumpier
junior1386142juni_or
junker174213652jun_ker
junkier18339492junkier
lunier64617602luni_er
punier84519222puni_er
sniper84413642_sniper
uniter64619142_uniter
unriper9188282_unriper
bonier84321993boni_er
bumper123714343bu_mper
bumpier13359203bumpier
bundler104011723bundler
bungler104611483bungler
bunker124519373bun_ker
bunter85020383bun_ter
burier84324653buri_er
busier85219723busi_er
caliper11410963caliper
conifer123212643conifer
cunner83915003cun_ner
cupper124313863cu_pper
cuppier1368323cuppier
denier74420693deni_er
duiker114110593du_iker
dumper114615213du_mper
dumpier12409653dumpier
dungier9368583dungier
dunite7315013dunite_
dunites8313593dunites
dunker113616463dun_ker
dunner73913823dun_ner
duper85519003du__per
fumier11310903fumi_er
funder104016083fun_der
funker133915763fun_ker
funkier14349983funkier
funner93414103fun_ner
funnier103210173funnier
griper94114613_griper
guider84313523gu_ider
gulper93410213gu_lper
gulpier1046953gulpier
gunite7414403gunite_
gunites8313123gunites
gunkier12369553gunkier
gunner73813983gun_ner
gunpaper1342623gunpaper
hanaper1237133hanaper
humper134115883hu_mper
humpier143110723humpier
hunger104015203hun_ger
hunker133917673hun_ker
hunkier144512143hunkier
hunter94817773hun_ter
igniter8147673igniter
ionizer162310123ionizer
jailer134316683j_ailer
jangler153811833jangler
janitor1436483janitor
japer146218883j__aper
jasper154610383j_asper
jauntier1535233jauntier
jiber145115703j__iber
jimper17389863j_imper
jingler154311093jingler
jinker174013543jin_ker
jiver155119053j__iver
jivier16438613jivi_er
joinder15337593joinder
joiner134114133j_oiner
jointer14379713jointer
jokier17618753joki_er
jouncier1734423jouncier
jubile152910263jubile_
jubilee16298293jubilee
jubiles16289373jubiles
judder15439423ju_dder
judger154411453ju_dger
juggler16418873juggler
juice14311323ju_ice_
juiced1636513ju_iced
juicers1636153ju_icers
juices1549423ju_ices
juicier1635463juicier
jumbler183910273jumbler
jumped183511553ju_mped
jumpers18399843ju_mpers
juncoes16338073juncoes
jungle144012653jungle_
jungled16349643jungled
jungles154112543jungles
junglier1644303junglier
juniors1475783juniors
junked184311693jun_ked
junkers184010863jun_kers
junket173815023jun_ket
junketer1943713junketer
junkie17339603junkie_
junkies183711693junkies
junkmen2033633junkmen
jupe134921003ju__pe_
jupes145218553ju__pes
juried144212443juri_ed
juries134120633juri_es
juster134617013ju_ster
knifer13598563_knifer
linier64423793lini_er
lucifer1234603lucifer
lumper103816653lu_mper
lumpier113410143lumpier
luncher123111413luncher
lunger75720423lun_ger
lunies64723013luni_es
lunker104718343lun_ker
miniver1238393miniver
moniker1338673moniker
mumper123513523mu_mper
muncher143610373muncher
munster93710523munster
nicer74618293__nicer
nipper103715713__nipper
niter55028973__niter
panier84425503pani_er
pinier84024693pini_er
piper96523193__piper
pulper103513273pu_lper
pulpier1148623pulpier
pumicer1335063pumicer
pumper124415553pu_mper
puncher143311673puncher
punisher1335773punisher
punker123718823pun_ker
punkier133512793punkier
punner84918153pun_ner
punnier93511263punnier
punster92911103punster
punter84320023pun_ter
quipper2095823quipper
quiver18278743qu_iver
reuniter838323reuniter
riper74328403__riper
rubier84814743rubi_er
ruiner64013643ru_iner
rulier65016353ruli_er
runner63814463run_ner
runnier74010113runnier
runover1034663runover
runtier73512853runtier
snider74413913_snider
snipe75320573_snipe_
sniped94913483_sniped
snipers93311773_snipers
snipes83917393_snipes
snipper113911333_snipper
striper94514793striper
suiter64121813su_iter
sunder74019823sun_der
sunnier73412153sunnier
super74924483su__per
supper104115433su_pper
tinier63622233tini_er
tonier65520713toni_er
tuner56022683tun__er
under64624213_un_der
undoer73113043_undoer
unifier102211863_unifier
unipod946853_unipod
uniquer1675783_uniquer
unisex1358353_unisex
unite54828383_unite_
united74421543_united
uniters73814173_uniters
unites65024853_unites
unmiter9310393_unmiter
unopen838913_unopen
unpeg8309363_un_peg
unpen72913573_un_pen
unripe82012093_unripe_
unwiser1037123_unwiser
upper93714263_u_pper
vinier93716743vini_er
viper105017303__viper
wanier93920683wani_er
winier94522453wini_er
wiper105421293__wiper
zanier154314713zani_er

Search took 7 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 Limit1340271916.48620664.0
3Display Results1911910.0762513.2
 (SQL Overall)1786911916.96825644.5
 
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.