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

179 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
schappes173603(None) 
schappe1635261schappe_
chapes135421872_cha_pes
chapped172711442_chapped
chappies172610092_chappies
scapes105122262sc_a_pes
schnapper1842472schnapper
schnappers1942142schnappers
schnapps1752032schnapp_s
scrapes116217662scra_pes
scrapies124612472scrapies
scrapped1556532scrapped
scrapper1466972scrapper
scrappers1545862scrappers
scrapples1534792scrapples
shapes115124942s_ha_pes
shoppes143411392s_hoppes
capes95441923_c_a_pes
capped134721853_c_apped
capper124421983_c_apper
cappers134419403_c_appers
chafes145017913_cha_fes
chaines124518733_chaines
chaises124317493_chaises
champed174111483_champed
champer163813413_champer
champers173311623_champers
champs154915683_champ_s
chances145218093_chances
changes134517583_changes
chaoses124715123_chaoses
chape125221143_cha_pe_
chapel134911373_cha_pel
chapels14429153_chapels
chaplet14512253_chaplet
chaplets1556883_chaplets
chapmen1637283_chapmen
chappie16298653_chappie
chaps125326063_cha_p_s
chapter144213853_chapter
chapters154012133_chapters
chares115631803_cha_res
charges134615983_charges
chases115128233_cha_ses
chasses124017503_chasses
cheapies1539033_cheapies
chipped174110813_chipped
chipper163912583_chipper
chippers173510883_chippers
chippies17309753_chippies
chopped174511003_chopped
chopper163611893_chopper
choppers174110463_choppers
chuppas1644123_chuppas
clapped143511173_clapped
clapper134011863_clapper
clappers143310833_clappers
crapes104727693_cra_pes
crapped143912623_crapped
crapper133913193_crapper
crappers144011023_crappers
crappies142911153_crappies
escapees12336333esc_apees
escapes113811673esc_a_pes
frappes14328383_frappes
happed144820103__happed
happen134812193__happen
happens14359173__happens
nappes104515623__nappes
rhaphes1534703_rhaphes
sapped114422013s__apped
sapper103822353s__apper
sappers113518903s__appers
sarapes94617743sara_pes
scabies11613333sc_abies
scales84529313sc_a_les
scalped124411993sc_alped
scalpel11377713sc_alpel
scalpels12345883sc_alpels
scalper113912923sc_alper
scalpers123710863sc_alpers
scalps104315233sc_alp_s
scamped144711963sc_amped
scamper134613163sc_amper
scampers143611033sc_ampers
scampies1439323scampies
scamps125014173sc_amp_s
scape96921843sc_a_pe_
scaped115519553sc_a_ped
scapose1147753sc_apose
scares85033003sc_a_res
scarped124314403sc_arped
scarper114814823sc_arper
scarpers124712513sc_arpers
scarphs14437413sc_arphs
scarps104718603sc_arp_s
scarves124511623sc_arves
scathes124515713sc_athes
scauper11379453sc_auper
scaupers12378173sc_aupers
scaups105411933sc_aup_s
schavs1436493scha__vs
schemes1489663sch_emes
schlepped1942233schlepped
schlepps1762563schlepps
schleps1445483schlep_s
schmalzes2543163schmalzes
schmattes1644323schmattes
schmoes14308543sch_moes
schnaps1443703schnap_s
schnozes2244493schnozes
schusses1334213schusses
scopes104719593sc__opes
scrape105917573scra_pe_
scraped124313133scra_ped
scraper114513423scra_per
scrapers125510533scrapers
scrapie115010943scrapie_
scrappages1742433scrappages
scrappier1544423scrappier
scrappiest1644153scrappiest
scrapple1434683scrapple
scrappy16234473scrapp_y
scraps106017243scra_p_s
scruples1237433scruples
scupper1367423sc_upper
scuppers1446543sc_uppers
serapes95218103sera_pes
shades105924533s_ha_des
shakes135024593s_ha_kes
shakoes144510023s_hakoes
shales94731253s_ha_les
shames114726223s_ha_mes
shammes144312833s_hammes
shape105125113s_ha_pe_
shaped125020103s_ha_ped
shapen114414653s_ha_pen
shaper114119933s_ha_per
shapers124016893s_hapers
shares95236413s_ha_res
sharped134112053s_harped
sharpen12389723s_harpen
sharpens13377813s_harpens
sharper124312703s_harper
sharpers133810943s_harpers
sharpest1339143s_harpest
sharpies13411223s_harpies
sharps115516083s_harp_s
shaves125224933s_ha_ves
shavies134213203s_havies
shipped153312103s_hipped
shippen14298863s_hippen
shippens15316803s_hippens
shipper143514043s_hipper
shippers153012313s_hippers
shnapps1463343shnapp_s
shoppe133110323s_hoppe_
shopped153512213s_hopped
shopper143312633s_hopper
shoppers153010763s_hoppers
slapped123511843s_lapped
slapper113512463s_lapper
slappers123710943s_lappers
snapped124611203s_napped
snapper113512073s_napper
snappers123510173s_nappers
stapes85028733s_ta_pes
staples93617213s_taples
steppes113110693s_teppes
strapped1357823strapped
strapper1258093strapper
strappers1346743strappers
swapped15429143s_wapped
swapper14359703s_wapper
swappers15358083s_wappers
synapses1344713synapses
whapped18367573_whapped
whapper17348273_whapper
whappers18276743_whappers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621796.53022383.2
3Display Results1791790.0632841.3
 (SQL Overall)1786911796.99925530.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.