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

143 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
spritzer194456(None) 
spritzed2044801spritzed
spritzers2043901spritzers
spritzes1946941spritzes
prizer174714882_pri_zer
spitter94015182sp_itter
spitzes1849182sp_itzes
splitter10348442splitter
sprier84119062spri__er
sprigger12366502sprigger
springer113311752springer
sprinter103810812sprinter
sprite84421772sprit_e_
sprites94220332sprit_es
spritz174714422spritz__
apprizer2145463appri_zer
blitzer18447663_blitzer
critter94113033_critter
fritter103912773_fritter
fritzes19329453_fritzes
frizer184011283_fri_zer
frizzer18446893_frizzer
gritter83913353_gritter
howitzer2341913howitzer
kibitzer2342033kibitzer
misprizer2245343mispri_zer
patzer173111643_p_atzer
pitier84019823_p_itier
potzer174411213_p_otzer
prater84825353_prat_er
pretzel1835143_pretzel
pricer103918293_pri_cer
pricier113313113_pricier
pricker154013413_pricker
prier75027763_pri__er
primer105118683_pri_mer
primmer134310163_primmer
prinker133412743_prinker
printer93917303_printer
prithee1239933_prithee
privier122910453_privier
prize164718943_pri_ze_
prized184415393_pri_zed
prizers183911843_pri_zers
prizes173819813_pri_zes
ritter63822423__ritter
ritzes154812943__ritzes
ritzier16297203__ritzier
sanitizer18126733sanitizer
scriber113910973scri_ber
scrimper1455763scrimper
scripter12137783scripter
seizer154114573s_ei_zer
seltzer1635213s_eltzer
shirtier1137943shirtier
shrieker15265653shrieker
shriller1136823shriller
shrimper1544413shrimper
shrinker15236363shrinker
shriver134712193shri_ver
sitter63323383s__itter
sizer145521813s__i_zer
skirter11338483skirt_er
skitter113810403s_kitter
slither104112983s_lither
slitter73615873s_litter
smiter83616413s_mit_er
sorites73825243sorit_es
sorter64425093sor_t_er
spatter94016523sp_atter
specter113111733spect_er
spelter94113703spelt_er
speltzes1944003speltzes
spicer104719313sp_i_cer
spicier115112463sp_icier
spider94516803sp_i_der
spieler93111233sp_ieler
spier75728033sp_i__er
spiker124315663sp_i_ker
spikier13369983sp_ikier
spiller92914333sp_iller
spinier93715163sp_inier
spinner93912263sp_inner
spirier93214073sp_irier
spirited1148973spirit_ed
spirituel1143213spirituel
spirted103913073spirt_ed
spite75430663sp_it_e_
spited94820443sp_it_ed
spites84127333sp_it_es
spitted103912703sp_itted
spitters104113383sp_itters
spitz166017973sp_itz__
splatter10348883splatter
splicer114710523spli_cer
splinter10329703splinter
splitters11307323splitters
splutter10357443splutter
spoiler93310683spoi_ler
sporter93616553sport_er
sportier102010053sportier
spotter94514883sp_otter
spottier10207313spottier
spouter94213223spout_er
sprawler1334653sprawler
sprayer12369043spr_ayer
spreader1137483spreader
sprigged13316223sprigged
spriggers13325493spriggers
spriggier1343843spriggier
springe103913983springe_
springed123911323springed
springers12309983springers
springes114014033springes
springier1236023springier
sprinkler1543573sprinkler
sprinted113411163sprinted
sprinters11329363sprinters
sprit76736403sprit___
sprits85122533sprit__s
spritzing2135393spritzing
sprucer11317683spr_ucer
sprucier1254793sprucier
spryer11418533spr__yer
spurter94013003spurt_er
sputter94014053sp_utter
straiter8311783strait_er
stricter1039423stricter
strider84315723stri_der
striker113714173stri_ker
stringer93812943stringer
striper94514793stri_per
stripier1058863stripier
stripper1247123stripper
striver104315203stri_ver
strutter846503strutter
suiter64121813s_uit_er
swither133710993s_wither
triter65120593_trit_er
upriser9218763upri_ser
upriver12196933upri_ver
writer94416513_writ_er
writher134010853_writher

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621436.36022981.4
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.82926166.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.