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

180 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
schnaps144370(None) 
schnapps1752031schnapps
shnaps1148081s_hnaps
chaps125326062_ch_aps
cheaps134613682_cheaps
scenas84114702scena_s
schavs1436492sch_avs
schleps1445482schleps
schwas14396982schwa_s
scraps106017242sc_raps
shnapps1463342s_hnapps
snaps74719562s__naps
canals84421673_canals
canape10913513_canape
canapes111213083_canapes
caps87147893_c__aps
catnaps1197033catnaps
chads116122233_ch_ads
chais107530313_ch_ais
champs154915683_champs
chams126028503_ch_ams
changs125215373_changs
chants115020393_chants
chaos105622863_ch_aos
chap114928493_ch_ap_
chape125221143_ch_ape
chapes135421873_ch_apes
chapt125827643_ch_apt
chars105936643_ch_ars
chats105730093_ch_ats
chaws135022463_ch_aws
chays135319743_ch_ays
cheap126915943_cheap_
cheapo134810083_cheapo
cheapos14418513_cheapos
cheats114519543_cheats
cheeps135312913_cheeps
chias104625523_chia_s
chiaus113611313_chiaus
chimps155713663_chimps
chinas115119403_china_s
chips125721253_ch_ips
chirps135414003_chirps
chomps155112223_chomps
chops125019873_ch_ops
chumps154313823_chumps
claps95626183_c_laps
craps95328643_c_raps
dognaps1134393dognaps
eschars1237183esch_ars
escheats1346253escheats
haps96443463__h_aps
heaps105223223__heaps
icecaps1343863icecaps
kidnaps1453323kidnaps
knaps115511173__knaps
naps66238583___naps
petnaps1145033petnaps
sannops936693sannops
sannups934463sannups
saps65346373s___aps
satraps95011643satraps
saunas63915433sauna_s
scabs94818643sc__abs
scads85419963sc__ads
scags85520973sc__ags
scalars93711903scalars
scalps104315233sc_alps
scamps125014173sc_amps
scams94423973sc__ams
scandals1136993scandals
scans74625103sc__ans
scants85219723scan_ts
scape96921843sc__ape
scapes105122263sc__apes
scarabs1137293scarabs
scarps104718603sc_arps
scars75433533sc__ars
scats75930603sc__ats
scaups105411933sc_aups
scena74815783scena__
scends95213003scen_ds
scenes84520353scen_es
scenics1137773scenics
scents85317023scen_ts
schappe1635273schappe
schappes1736043schappes
schav1338313sch_a_v
schemas1468163schemas
schemes1489663schemes
schisms1437173schisms
schists1248543schists
schizos21115433schizos
schlep1347093schlep_
schlepp1662953schlepp
schlepps1762563schlepps
schlubs1443193schlubs
schlumps1742743schlumps
schmalz2345293schmalz
schmears1584103schmears
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153sch_mos
schnapper1842473schnapper
schnappers1942143schnappers
schnook1654483schnook
schnooks1754243schnooks
schnoz2035653schn_oz
schnozes2244493schnozes
schnozz2042733schnozz
scholars1336683scholars
schools1249113schools
schorls1248353schorls
schriks16185743schriks
schrods1337433schrods
schtiks16184743schtiks
schuits1235823schuits
schuls11299853sch_uls
schuss11186733sch_uss
schwa13426843schwa__
sconces113811453sconces
scones84521303scon_es
scoops105414363sc_oops
scops95820193sc__ops
scrags95713803sc_rags
scrams105216623sc_rams
scrap97120403sc_rap_
scrape105917573sc_rape
scrapes116217663sc_rapes
screaks13469363screaks
screams114810623screams
scrimps13517903scrimps
scrips105316033sc_rips
scroops11288253scroops
scubas103710223scuba_s
sculps104611753sc_ulps
scups95316653sc__ups
seconals1047053seconals
sennas64214233senna_s
shads95124483s_h_ads
shags95123863s_h_ags
shahs115919513s_h_ahs
shams105829413s_h_ams
shanks135315583s_hanks
shape105125113s_h_ape
shapes115124953s_h_apes
sharps115516083s_harps
shaws116226263s_h_aws
shays116021433s_h_ays
sheafs124912883s_heafs
sheals94420643s_heals
shears93820903s_hears
sheas86331793s_hea_s
ships105123773s_h_ips
shleps114710333s_hleps
shoals94215793s_hoals
shoats94117083s_hoats
shops104222903s_h_ops
shwas116415103s_hwa_s
signals8359163signals
skycaps1842703skycaps
slaps76025713s__laps
snags64421313s__nags
snap65727033s__nap_
snaws86116363s__naws
sneaps84510863s_neaps
snips75818013s__nips
soaps75120713s__oaps
sonars64818973s_onars
spinals93911863spinals
straps87721783s_traps
suchness1335763suchness
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunups837263s_unups
swaps104819203s__waps
synapse1234133s_ynapse
unsnaps935423unsnaps
upheaps1494233upheaps
whaps135115163_wh_aps

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271807.00019146.7
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.46923924.4
 
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.