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

133 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
scrappier154442(None) 
crappier14288131_crappier
scrapper1466971scrapp_er
strappier1345131strappier
crampier14288902_crampier
crapper133913192_crapp_er
crappie13298982_crappie_
crappies142911152_crappies
sappier113613112s__appier
scraggier1344132scraggier
scraper114513422scra_p_er
scrapie115010942scra_pie_
scrapies124612472scra_pies
scrapped1556532scrapp_ed
scrappers1545862scrapp_ers
scrappiest1644152scrappiest
scrappily1842672scrappily
scrapping1635742scrapping
scrapple1434682scrapple_
scrapples1534792scrapples
scrawlier1443902scrawlier
scrawnier1443642scrawnier
scrimpier1554242scrimpier
snappier1266212s_nappier
strapper1258092strapp_er
stroppier1364452stroppier
campier133313273_c_ampier
capper124421983_c_app_er
chappie16298653_chappie_
chappies172610093_chappies
chippier17297673_chippier
choppier17286643_choppier
clapper134011863_clapp_er
crabbier14326803_crabbier
craftier1376193_craftier
craggier12116063_craggier
crankier14339163_crankier
crapped143912623_crapp_ed
crappers144011023_crapp_ers
crappiest15267263_crappiest
crapping153911453_crapping
crawlier13216873_crawlier
crazier183610743_cra_zier
creepier1236253_creepier
crepier1139743_cr_epier
crimpier14287323_crimpier
crippler14826713_crippler
crispier12297253_crispier
cropper133312963_cropp_er
croppie13278793_croppie_
croppies143111133_croppies
croupier1246883_croupier
crupper13338563_crupp_er
cuppier1368323_c_uppier
drippier1385043_drippier
flappier1544293_flappier
gappier12369843__gappier
grapier103712603_gra_pier
grappler13336193_grappler
grippier1355203_grippier
happier143312033__happier
nappier114411173__nappier
pappier103511593__pappier
preppier1156643_preppier
rapier84019993__ra_pier
rapper104621573__rapp_er
raspier93110643__raspier
sapper103822353s__app_er
scabbier1435133sc_abbier
scalier94316913sc_a_lier
scalper113912923sc_alp_er
scamper134613163sc_amp_er
scampies1439323sc_ampies
scantier10309983sc_antier
scarier94017873sc_a_rier
scarifier1446653scarifier
scarper114814823sc_arp_er
scarrier10298453sc_arrier
scattier10267583sc_attier
scauper11379453sc_aup_er
schappe1635263schapp_e_
schappes1736033schapp_es
schnapper1842473schnapp_er
scrabbler15195203scrabbler
scrabblier1642773scrabblier
scragglier1442283scragglier
scrambler15165043scrambler
scrape105917573scra_p_e_
scraped124313133scra_p_ed
scrapers125510533scra_p_ers
scrapes116217663scra_p_es
scraping133310863scra_ping
scrappage1642443scrappage
scrappages1742433scrappages
scrappiness1752283scrappiness
scrappy16234473scrapp__y
scratcher1635443scratcher
scratchier1744343scratchier
scrawler1345893scra_wler
screwier1346433scr_ewier
scrimper1455763scrimp_er
scripter12137783scr_ipter
scroggier1343133scroggier
scrubbier1543333scrubbier
scruffier1743303scruffier
scupper1367423sc_upp_er
shrimpier1643063shrimpier
sirupier1034303sir_upier
slapper113512463s_lapp_er
slippier1256533s_lippier
sloppier1255703s_loppier
snapper113512073s_napp_er
snippier1255793s_nippier
soapier93411713s_oa_pier
soppier112711583s__oppier
sprawlier1443293sprawlier
strapped1357823strapp_ed
strappers1346743strapp_ers
strappiest1444373strappiest
strapping1436993strapping
strawier1137493stra_wier
stripier1058863str_ipier
stripper1247123stripp_er
stropper1247763stropp_er
swampier1544593s_wampier
swapper14359703s_wapp_er
syrupier1343053syr_upier
trampier12318243_trampier
trapper113912803_trapp_er
trippier1246623_trippier
unhappier1642393unhappier
wrapper14368333_wrapp_er
zappier20458373__zappier

Search took 7 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 Filter1786911486410.470380193.6
2DLD Change Limit1486411336.31023556.4
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.84326113.0
 
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.