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

377 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
prissing11301145(None) 
pissing103914801p_issing
pressing112516441pressing
prising103321451pri_sing
arising83619972ari_sing
blissing1136872blissing
brassing112612302brassing
brisking15329472brisking
brisling112410842brisling
crisping13319662crisping
crossing112612692crossing
dissing94517682_dissing
dressing102810422dressing
frisking16268362frisking
grassing103311972grassing
grossing103111062grossing
hissing114213142_hissing
irising83614422iri_sing
kissing122911052_kissing
missing103619072_missing
passing104318422p_assing
peising103416762pei_sing
perishing1539532perishing
pishing134314372p_ishing
poising103617102poi_sing
praising113214562praising
pressings12269022pressings
pricing123417342pri_cing
pricking173212602pricking
priding113317542pri_ding
priesting1239482priesting
prigging13299092prigging
prilling113413412prilling
priming123417372pri_ming
primming15268172primming
primping15338892primping
prinking153212452prinking
printing113216082printing
prisoning1237642prisoning
prissier10157872prissier
prissies101712002prissies
prissily1346692prissily
pristine10313502pristine
prizing193514682pri_zing
prosing103319382pr_osing
rinsing82516112_rinsing
rising74025882_ri_sing
risking123914242_risking
trussing9268652trussing
uprising1138952upri_sing
wissing113212942_wissing
agisting1038243agisting
aliasing9310073aliasing
amassing1138003amassing
apprising1447963appri_sing
arousing93811803arousing
bekissing1643503bekissing
biasing103512453_biasing
biassing11307263biassing
blessing1137593blessing
bossing103714603_bossing
braising113014563braising
bribing123111043bri_bing
bricking173911403bricking
bridging13288443bridging
bridling122610583bridling
briefing1436943briefing
brimming15196623brimming
bringing123011273bringing
brining103216473bri_ning
brislings12236363brislings
bristling1246663bristling
browsing14319353browsing
bruising11279143bruising
brushing14359963brushing
bussing103614623_bussing
caressing1238803caressing
cessing103814813_cessing
classing113211793classing
crashing143512633crashing
creasing113314443creasing
cresting114017043cresting
cribbing15276843cribbing
cricking173412653cricking
crimping15299783crimping
cringing123311383cringing
crossings12217163crossings
cruising112610153cruising
crushing143010053crushing
crusting113612793crusting
cussing103814273_cussing
depressing1448093depressing
discing113914593_discing
dishing124017103_dishing
disking134615493_disking
disusing1039013_disusing
dossing93313273_dossing
dressings11265373dressings
dribbing14325883dribbing
drifting13338733drifting
drilling103311983drilling
drinking14308913drinking
dripping14278033dripping
driving123910713dri_ving
drowsing13287773drowsing
egressing1146853egressing
enisling949633enisling
erasing8317963er_asing
existing1639073existing
expressing2046623expressing
fessing113812863_fessing
fishing143913863_fishing
fisting113818123_fisting
flossing12247903flossing
foisting122910503foisting
freshing152611023freshing
frigging14268953frigging
frilling123011493frilling
fringing133010903fringing
frisson1045313frisson_
frissons1145043frissons
fritting123510703fritting
frizing203310873fri_zing
frizzing2064803frizzing
frosting12311183frosting
fussing113611683_fussing
gassing94216333_gassing
glassing10329973glassing
glossing10278883glossing
grasping12348833grasping
greasing102811393greasing
griding103014973gri_ding
grieving1385893grieving
grifting13299263grifting
grilling103811533grilling
griming113612493gri_ming
grinding1139863grinding
grinning1037863grinning
griping113012063gri_ping
gripping14277543gripping
griskin1236013griskin_
griskins1335953griskins
gritting10309983gritting
grousing103410453grousing
guessing1036243guessing
guising93511413gui_sing
harassing1346983harassing
heisting123411043heisting
hirsling1277543hirsling
hissings12556753_hissings
histing113720373_histing
hoising113414413hoi_sing
hoisting123610903hoisting
impressing1547543impressing
isling71213883__isling
issuing836053__issuing
jessing153710623_jessing
joisting16328503joisting
lisping103412753_lisping
listing84020593_listing
massing104318023_massing
messing103916393_messing
misting103623383_misting
misusing1138893_misusing
mossing103915423_mossing
moussing1138143moussing
mussing104015543_mussing
noising83615173noi_sing
oppressing1545973oppressing
paiking143814813pai_king
paining103920243pai_ning
painting113614423painting
pairing103716733pai_ring
palsying1436233palsying
parsing103819553p_arsing
pashing135120513p_ashing
passings11409873p_assings
pasting103826553p_asting
pausing103912813p_ausing
peining104619153pei_ning
percussing1545223percussing
perfusing1565633perfusing
periling11316863peri_ling
perilling12410003perilling
persisting1346653persisting
perusing11811063perusing
phasing133211673p_hasing
phrasing1438013phrasing
picking163418333p_icking
piecing12410453p_iecing
pieing93917653p_i_eing
pigging123614673p_igging
piing85218833p_i__ing
piking133719643p_i_king
piling95025593p_i_ling
pilling103722563p_illing
pimping143812123p_imping
pinging113419553p_inging
pining93726533p_i_ning
pinking143918943p_inking
pinning103417853p_inning
piping114017453p_i_ping
pipping113414743p_ipping
piquing1935873p_iquing
pirating11314513pirating
piscina1177043p_iscina
piscine11610973p_iscine
pissant91012503p_issant
pithing134014053p_ithing
pitting103618873p_itting
pitying132910243p_itying
plashing143311063plashing
pleasing112611593pleasing
plinking153611243plinking
poinding122510003poinding
pointing112813683pointing
poisoning1245903poisoning
polishing1536923polishing
posing93922643p__osing
positing11312303positing
posting105622243p_osting
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prating103424453pr_ating
prawning1446963prawning
praying133717323pr_aying
preassign1244573preassign
precessing1598743precessing
precising14413273precising
preeing103817673pr_eeing
preening113115843preening
premising14412413premising
prepping12309763prepping
prerinsing1347643prerinsing
presaging1339393presaging
prescind1338393prescind
presiding13510903presiding
presong1039843pr_esong
pressgang1342773pressgang
pressingly1646003pressingly
pressuring1346513pressuring
presuming1437663presuming
prevising15510873prevising
prevuing1457253prevuing
preying133114553pr_eying
prickings18315653prickings
prickling1836533prickling
primine113214823pri_mine
primings13338143pri_mings
primsie1137543primsi_e
printings12268103printings
prison8514023pri_son_
prisons9313223pri_sons
priss74623893priss___
prissed103311263priss_ed
prisses94816713priss_es
prissiest11178903prissiest
prissiness1266153prissiness
prissy11347853priss__y
pristane10310343pristane
probing123314443pr_obing
processing15108183processing
prodding13189343prodding
professing16106623professing
progging132610383progging
promising14410973promising
promoing13310463promoing
pronging123511843pronging
proofing1439313proofing
proposing1439673proposing
propping122811673propping
prossie91812963prossi_e
prossies101515233prossies
proving134214073pr_oving
prowling1449993prowling
pruning10311733pr_uning
prussic1144743prussi_c
prying124114803pr__ying
puissant10105393puissant
pulsing103712863p_ulsing
punishing1545383punishing
purifying1835853purifying
purposing1445233purposing
pursing103715553p_ursing
pursuing1146233pursuing
pushing133615453p_ushing
quisling18218063quisling
raising83220533_raising
rasing74330833_r_asing
rasping104316253_rasping
rassling939013_rassling
reissuing1034613reissuing
repressing13310393repressing
reprising12312553repri_sing
rerising93017783reri_sing
resting85031183_resting
reusing82516783_reusing
ribbing123111953_ribbing
ricing94822763_ri_cing
ricking143920233_ricking
ridding103314193_ridding
ridging104112983_ridging
riding84325963_ri_ding
riesling939013_riesling
riffing144011273_riffing
rifling112815013_rifling
rifting113515003_rifting
rigging103016333_rigging
riling74227973_ri_ling
rilling84023623_rilling
riming93322223_ri_ming
rimming123411073_rimming
ringing93521283_ringing
rinning83216743_rinning
rinsings9318013_rinsings
rioting82716393_rioting
riping93821613_ri_ping
ripping123315743_ripping
risings83211893_ri_sings
riving104521423_ri_ving
roosing84018133_roosing
rosing73925593_r_osing
rousing83920553_rousing
rushing113817703_rushing
rusting83821263_rusting
sassing84615553_sassing
seising84018863sei_sing
sprigging1435893sprigging
springing1338743springing
sprinting12310033sprinting
spritzing2135393spritzing
stressing1038333stressing
sussing84013703_sussing
swishing15277813swishing
tissuing935103_tissuing
tossing83612563_tossing
traipsing1235073traipsing
trashing122613223trashing
triaging102610543triaging
tricing103417353tri_cing
tricking152714513tricking
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tri_ning
tripling112712553tripling
tripping133210923tripping
trithing122811773trithing
trussings10224033trussings
trusting93411653trusting
trysting12267053trysting
twisting12427813twisting
upraising1237263upraising
uprisings1243343upri_sings
uprousing1235623uprousing
uprushing1544043uprushing
uptossing1243523uptossing
visaing11279333_visaing
viseing11299163_viseing
vising103915873_vi_sing
waisting123615213waisting
whishing18287183whishing
whisking19286613whisking
whisting15329543whisting
wishing144114893_wishing
wising103318223_wi_sing
wisping133711943_wisping
wisting113519743_wisting
wrassling1334273wrassling
wresting123811833wresting
wricking18349493wricking
wringing13279623wringing
writhing15278673writhing
writing113713893wri_ting
yessing113210063_yessing

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 Limit1461623777.51619446.8
3Display Results3773770.1562416.7
 (SQL Overall)1786913778.10822038.9
 
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.