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

129 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
junipers173393(None) 
juniper1634021juniper_
juicers1636152ju_icers
jumpers18399842ju_mpers
juniors1475782juni_ors
junkers184010862jun_kers
snipers93311772_snipers
uniters73814172_uniters
bumpers133912053bu_mpers
bundlers11399183bundlers
bunglers11398483bunglers
bunkers133715953bun_kers
bunters94717123bun_ters
buriers94017193buri_ers
calipers1249443calipers
conifers133611703conifers
cunners93913473cun_ners
cuppers133712213cu_ppers
deniers84515183deni_ers
duikers12369383du_ikers
dumpers123412663du_mpers
dunites8313593dunite_s
dunkers123512193dun_kers
dupers94615603du__pers
funders113813933fun_ders
funkers143712063fun_kers
gripers104011463_gripers
guiders94111113gu_iders
gulpers10299013gu_lpers
gunites8313123gunite_s
gunners83111733gun_ners
gunpapers1442423gunpapers
hanapers1346963hanapers
humpers142713523hu_mpers
hungers114013303hun_gers
hunkers143314333hun_kers
hunters103915733hun_ters
igniters9126233igniters
ionizers17257713ionizers
jailers144114043j_ailers
janglers16319373janglers
janitors1536853janitors
japers154616173j__apers
jaspers164310463j_aspers
jeepers16399193j_eepers
jibers155912883j__ibers
jinglers16408763jinglers
jinkers183511813jin_kers
jivers164515643j__ivers
joinders16337203joinders
joiners144211573j_oiners
jointers15289323jointers
jubilees17244423jubilees
jubiles16289373jubile_s
judders16347793ju_dders
judgers16369043ju_dgers
jugglers17366523jugglers
juicer1536283ju_icer_
juices1549423ju_ice_s
jumblers19358323jumblers
jumper173612373ju_mper_
jumpier18317943jumpier_
juncoes16338073juncoe_s
jungles154112543jungle_s
junior1386143juni_or_
junker174213653jun_ker_
junketers2042933junketers
junkets18377623jun_kets
junkier18339493junkier_
junkies183711693junkie_s
jupes145218553ju__pe_s
juries134120633juri_e_s
justers143815733ju_sters
knifers14537083_knifers
lucifers1334163lucifers
lumpers113514483lu_mpers
lunchers13349563lunchers
lungers83817093lun_gers
lunier64617603luni_er_
lunies64723013luni_e_s
lunkers113414603lun_kers
minivers1337483minivers
monikers1437413monikers
mumpers133311373mu_mpers
munchers15318773munchers
munsters104010553munsters
nippers113012623__nippers
niters64624213__niters
paniers94717333pani_ers
pipers104318663__pipers
pulpers114612283pu_lpers
pumicers1434353pumicers
pumpers133113673pu_mpers
punchers152610073punchers
punier84519223puni_er_
puniness101610273puniness
punishers1434973punishers
punkers133714853pun_kers
punners94114233pun_ners
punsters103310583punsters
punters93617043pun_ters
quippers2184813quippers
quivers19298753qu_ivers
reuniters936423reuniters
ruiners74213023ru_iners
runners74212453run_ners
runovers1134473runovers
sniper84413643_sniper_
snipes83917393_snipe_s
snippers12299723_snippers
stripers103911593stripers
suiters73618883su_iters
sunders84120053sun_ders
supers84622403su__pers
suppers113314703su_ppers
tuners64417343tun__ers
undoers82910583_undoers
unifiers11237173_unifiers
unipods1095703_unipods
uniter64619143_uniter_
unites65024853_unite_s
universe1145253_universe
unmiters1037073_unmiters
unpegs9256233_un_pegs
unpens82511013_un_pens
unriper9188283_unriper_
uppers102912293_u_ppers
vipers114914533__vipers
wipers115416083__wipers

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.420425454.8
2DLD Change Limit1461621297.03020791.2
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.50023825.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.