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

151 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
shnapps146334(None) 
schnapps1752031schnapps
shnaps1148081shna_ps
schnaps1443702schna_ps
shapes115124942sh_apes
sharps115516082sh_arps
shlepps14394832shlepps
snappy1366102s_nappy
snaps74719562s_na_ps
apps86319693___apps
canapes111213083canapes
champs154915683ch_amps
chapes135421873ch_apes
chaps125326063ch_a_ps
cheapos14418513cheapos
cheaps134613683chea_ps
happy155813533_h_appy
haps96443463_h_a_ps
harps105926863_h_arps
hasps105114643_h_asps
heaps105223223_hea_ps
khaphs18394323kh_aphs
knaps115511173_kna_ps
napas75924353__napas
napes74828463__napes
nappa98511863__nappa
nappas105511613__nappas
nappe96114993__nappe
nappes104515623__nappes
nappy126312333__nappy
naps66238583__na_ps
salps74423243s__alps
samps96124673s__amps
sannops936693sannops
sannups934463sannups
sappy125413473s__appy
saps65346373s__a_ps
sarapes94617743sarapes
scalps104315233s_calps
scamps125014173s_camps
scapes105122263s_capes
scarps104718603s_carps
scaups105411933s_caups
schappe1635263schappe
schappes1736033schappes
schlepps1762563schlepps
schnapper1842473schnapper
schnappers1942143schnappers
scrapes116217663scrapes
scrappy16234473scrappy
scraps106017243scra_ps
senates73322583senates
sendups10115193sendups
serapes95218103serapes
seraphs12408093seraphs
shacks154817563sh_acks
shades105924533sh_ades
shads95124483sh_a_ds
shafts125411433sh_afts
shags95123863sh_a_gs
shahs115919513sh_a_hs
shakes135024593sh_akes
shakos134912183sh_akos
shales94731253sh_ales
shamas113717943sh_amas
shames114726223sh_ames
shamos114216983sh_amos
shams105829413sh_a_ms
shamus114112813sh_amus
shanks135315583sh_anks
shantis103313093shantis
shape105125113sh_a_pe
shaped125020103sh_aped
shapen114414653sh_apen
shaper114119933sh_aper
shapers124016893sh_apers
shapeups1542723sh_apeups
shards104319173sh_ards
shares95236413sh_ares
sharks135019723sh_arks
sharns95516983sh_arns
sharp104922533sh_arp_
sharpy145211033sh_arpy
shauls94913113sh_auls
shaves125224933sh_aves
shawls125411973sh_awls
shawms14579563sh_awms
shaws116226263sh_a_ws
shays116021433sh_a_ys
sheafs124912883shea_fs
sheals94420643shea_ls
shears93820903shea_rs
sheas86331793shea__s
sheaths1358743sheaths
sheaves134412973sheaves
sherpas1238093sherpas
ships105123773sh__ips
shlepp13366193shlepp_
shleps114710333sh_leps
shlumps1434143shlumps
shnooks1485573shnooks
shoals94215783shoa_ls
shoats94117073shoa_ts
shoppe133110313sh_oppe
shoppes143411383shoppes
shops104222893sh__ops
shrimps14516753shrimps
shwas116415103shwa__s
sinapism1245573sinapism
slaps76025713s_la_ps
snacks124514553s_nacks
snafus936743s_nafus
snags64421313s_na_gs
snails64816653s_nails
snakes103919603s_nakes
snap65727033s_na_p_
snapped124611203s_napped
snapper113512073s_napper
snappers123510173s_nappers
snappish1545233s_nappish
snares65329033s_nares
snarfs95113423s_narfs
snarks104815733s_narks
snarls64016873s_narls
snaths95112913s_naths
snaws86116363s_na_ws
sneaps84510863s_neaps
snipes83917393s_nipes
snippy1374843s_nippy
snips75818013s_n_ips
snoops84314173s_noops
soaps75120713s_oa_ps
sonants7511233sonants
sonars64818973sona_rs
sonatas7510293sonatas
stamps105614023s_tamps
stapes85028733s_tapes
staphs114411033s_taphs
strappy14205263strappy
straps87721783stra_ps
sunlamps1243293sunlamps
sunups837263sun_ups
swamps135910263s_wamps
swaps104819203s_wa_ps
synapse1234133synapse
synapses1344713synapses
synapsis1345143synapsis
syncarps1543903syncarps
unhappy1742803unhappy
whaps135115163wh_a_ps
whaups14405753wh_aups

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.1701051123.5
2DLD Change Limit1340271517.59317651.4
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.82622833.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.