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 “knaps” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
knaps11551117(None) 
knap105815401knap_
knars94416111knars
knops115911811knops
naps66238581_naps
snaps74719561snaps
anas46649862ana_s
ataps76414832ataps
baps86040842_baps
caps87147892_caps
chaps125326062chaps
claps95626182claps
craps95328642craps
daps77239162_daps
flaps105621382flaps
fraps105620552fraps
gaps76042972_gaps
gnars66718852gnars
gnats65217712gnats
gnaws96311142gnaws
haps96443462_haps
heaps105223222heaps
inapt73522692inapt
kaas86531842k_aas
kabs107130842k_abs
kaes85734062k_aes
kafs116423742k_afs
kanas95326912kanas
kanes95529372kanes
kapa106021292k_apa
kapas116021732k_apas
kaph135815752k_aph
kaphs144911502k_aphs
kas77058582k_a_s
kats85944332k_ats
kays116032192k_ays
kbars114612602kbars
keas86337092kea_s
keeps116020282keeps
kelps115116422kelps
kemps135012522kemps
kenafs1337112kenafs
keps106027302k_eps
khafs15648842khafs
khans124615172khans
khaph17395962khaph
khaphs18394322khaphs
khats125316012khats
kidnaps1453322kidnaps
kinas95626912kina_s
kips106430512k_ips
knack104311042knack
knacks11428542knacks
knar85818722kna_r
knaur9508252knaur
knaurs10466962knaurs
knave12389462knave
knaves13439522knaves
knawe12397882knawe
knawes13328392knawes
kneads11357092kneads
knees95114872knees
knits93914742knits
knobs11519712knobs
knop107116592knop_
knosp11576822knosp
knosps12405012knosps
knots95614722knots
knows124912412knows
knurs94511152knurs
koans95818622koans
koas85635092koa_s
kops107031292k_ops
kvas117015942kva_s
kvass12507272kvass
kyaks11459162kyaks
kyars124813962kyars
kyats125012442kyats
laps66848872_laps
leaps75522932leaps
maps86141042_maps
nabs66236192_nabs
nags55436022_nags
nans46139392_nans
naos47429732_naos
nap56753202_nap_
napa66927262_napa
napas75924352_napas
nape65230802_nape
napes74828462_napes
nays75931592_nays
neaps75618322neaps
nips65830922_nips
paps86443452_paps
raps66247732_raps
reaps75626192reaps
saps65346372_saps
shnaps1148082shnaps
slaps76025712slaps
snags64421312snags
snap65727032snap_
snaws86116362snaws
sneaps84510862sneaps
snips75818012snips
soaps75120712soaps
swaps104819202swaps
taps66050672_taps
traps75727482traps
unais53420772unais
unapt710421592unapt
unaus53216572unaus
uncaps1039812uncaps
waps96642082_waps
whaps135115162whaps
wraps105617152wraps
yaps95933522_yaps
zaps156826892_zaps

Search took 3 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 Filter178691538000.0961861364.6
2DLD Change Limit538001171.93627789.3
3Display Results1171170.0303900.0
 (SQL Overall)1786911172.06286659.1
 
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.