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

163 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
schappe163526(None) 
schappes1736031schappes
chape125221142_cha_pe
chapped172711442_chapped
chappie16298652_chappie
scape96921842sc_a_pe
schnapper1842472schnapper
schnapps1752032schnapps
scrape105917572scra_pe
scrapie115010942scrapie
scrapped1556532scrapped
scrapper1466972scrapper
scrapple1434682scrapple
scrappy16234472scrappy
shape105125112s_ha_pe
shoppe133110322s_hoppe
cape87242783_c_a_pe
capped134721853_c_apped
capper124421983_c_apper
chafe135117353_cha_fe
chaine115119223_chaine
chaise114916413_chaise
champ145017963_champ_
champed174111483_champed
champer163813413_champer
champs154915683_champs
champy18509613_champy
chance134617093_chance
change124116753_change
chap114928493_cha_p_
chapel134911373_chapel
chapes135421873_chapes
chaplet14512253_chaplet
chapmen1637283_chapmen
chappies172610093_chappies
chaps125326063_cha_ps
chapt125827643_cha_pt
chapter144213853_chapter
chare105231983_cha_re
charge125114213_charge
chase105127123_cha_se
chasse115114603_chasse
chaste114617393_chaste
cheapie1437563_cheapie
chipped174110813_chipped
chipper163912583_chipper
chippie16297693_chippie
chippy18437613_chippy
chopped174511003_chopped
chopper163611893_chopper
choppy18376293_choppy
chuppa1543973_chuppa
clapped143511173_clapped
clapper134011863_clapper
crape96128443_cra_pe
crapped143912623_crapped
crapper133913193_crapper
crappie13298983_crappie
crappy15446803_crappy
escape103811663esc_a_pe
escapee113310463esc_apee
frappe13286953_frappe
happed144820103__happed
happen134812193__happen
happy155813533__happy
nappe96114993__nappe
rhaphe1433423_rhaphe
sapped114422013s__apped
sapper103822353s__apper
sappy125413473s__appy
sarape84817573sara_pe
scale74629143sc_a_le
scalp95217983sc_alp_
scalped124411993sc_alped
scalpel11377713sc_alpel
scalper113912923sc_alper
scalps104315233sc_alps
scamp115717313sc_amp_
scamped144711963sc_amped
scamper134613163sc_amper
scampi12469103sc_ampi
scamps125014173sc_amps
scaped115519553sc_aped
scapes105122263sc_apes
scapose1147753sc_apose
scarce104013633sc_arce
scare75334463sc_a_re
scarp95724103sc_arp_
scarped124314403sc_arped
scarper114814823sc_arper
scarph13429603sc_arph
scarps104718603sc_arps
scathe114414993sc_athe
scaup95515993sc_aup_
scauper11379453sc_auper
scaups105411933sc_aups
schav1338313scha__v
schavs1436493scha_vs
scheme1379633sch_eme
schlep1347093schlep_
schlepp1662953schlepp
schlepped1942233schlepped
schlepps1762563schlepps
schleps1445483schleps
schmatte1544473schmatte
schmoe13328333sch_moe
schnappers1942143schnappers
schnaps1443703schnaps
scope94821483sc__ope
scrap97120403scra_p_
scraped124313133scraped
scraper114513423scraper
scrapes116217663scrapes
scrapies124612473scrapies
scrappage1642443scrappage
scrappers1545863scrappers
scrappier1544423scrappier
scrapples1534793scrapples
scraps106017243scra_ps
scruple1137193scruple
scupper1367423sc_upper
serape84818413sera_pe
shade95125583s_ha_de
shake124726403s_ha_ke
shale85332833s_ha_le
shame105726703s_ha_me
shaped125020103s_haped
shapen114414653s_hapen
shaper114119933s_haper
shapes115124943s_hapes
share86437083s_ha_re
sharp104922533s_harp_
sharped134112053s_harped
sharpen12389723s_harpen
sharper124312703s_harper
sharpie1238393s_harpie
sharps115516083s_harps
sharpy145211033s_harpy
shave114425893s_ha_ve
shavie124312423s_havie
shipped153312103s_hipped
shippen14298863s_hippen
shipper143514043s_hipper
shnapps1463343shnapps
shopped153512213s_hopped
shopper143312633s_hopper
shoppes143411393s_hoppes
slapped123511843s_lapped
slapper113512463s_lapper
snapped124611203s_napped
snapper113512073s_napper
snappy1366103s_nappy
staple84415823s_taple
steppe10319873s_teppe
strapped1357823strapped
strapper1258093strapper
strappy14205263strappy
swapped15429143s_wapped
swapper14359703s_wapper
synapse1234133synapse
unhappy1742803unhappy
whapped18367573_whapped
whapper17348273_whapper

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 Limit1340271636.81319672.2
3Display Results1631630.0463543.5
 (SQL Overall)1786911637.26524596.1
 
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.