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

289 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
crappier1428813(None) 
crampier14288901crampier
crapper133913191crapp_er
crappie13298981crappie_
crappies142911161crappies
scrappier1544431scrappier
campier133313272c_ampier
capper124421982c_app_er
chappie16298662chappie_
chappies172610102chappies
chippier17297672chippier
choppier17286642choppier
clapper134011862clapp_er
crabbier14326802crabbier
craftier1376192craftier
craggier12116062craggier
crankier14339162crankier
crapped143912622crapp_ed
crappers144011022crapp_ers
crappiest15267272crappiest
crapping153911452crapping
crawlier13216872crawlier
crazier183610742cra_zier
creepier1236252creepier
crepier1139742cr_epier
crimpier14287322crimpier
crippler14826712crippler
crispier12297252crispier
cropper133312962cropp_er
croppie13278792croppie_
croppies143111132croppies
croupier1246882croupier
crupper13338562crupp_er
cuppier1368322c_uppier
drippier1385042drippier
flappier1544302flappier
gappier12369842_gappier
grapier103712602gra_pier
grappler13336192grappler
grippier1355202grippier
happier143312042_happier
nappier114411172_nappier
pappier103511602_pappier
preppier1156642preppier
rapier84019992_ra_pier
rapper104621572_rapp_er
raspier93110642_raspier
sappier113613122_sappier
scrapper1466972scrapp_er
snappier1266222snappier
strappier1345142strappier
trampier12318242trampier
trapper113912802trapp_er
trippier1246622trippier
wrapper14368332wrapp_er
zappier20458372_zappier
applier1137903__applier
braggier12136453braggier
brainier102510233brainier
brakier133812363bra_kier
brannier10218933brannier
brashier13389933brashier
brasier94516753bra_sier
brassier103310533brassier
brattier1047663brattier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473bra_zier
cagier93715933c_a_gier
cahier113615773c_a_hier
cakier123115243c_a_kier
caliper11410963c_aliper
camper124722213c_amp_er
cannier94014163c_annier
caper94831623c_a_p_er
caperer113013403c_aperer
caponier1237883c_aponier
capped134721853c_app_ed
cappers134419403c_app_ers
capping143819673c_apping
carper104923633c_arp_er
carrier93619583c_arrier
cashier123713323c_ashier
cattier93317073c_attier
chaffier1935473chaffier
chalkier1736753chalkier
champer163813413champ_er
chancier1538823chancier
chapiter1536603chapiter
chapped172711443chapp_ed
chapping183710723chapping
chapter144213853cha_pter
charier124317903cha_rier
charrier1378683charrier
chattier1337513chattier
chipper163912583chipp_er
chippie16297693chippie_
chippies17309763chippies
chirpier15276303chirpier
chopper163611893chopp_er
clammier1435843clammier
clamper134012993clamp_er
clankier14327083clankier
clapped143511173clapp_ed
clappers143310833clapp_ers
clapping153810603clapping
clasper113811863clasp_er
classier10359083classier
clavier1239173cla_vier
clayier1248323cla_yier
clipper133710323clipp_er
clumpier1435583clumpier
coalier93416183coa_lier
coappear1442893coappear
complier14310253complier
copier103722893c__opier
copper124321893c_opp_er
crabber133810733cra_bber
cracker153114173cra_cker
cracklier1744823cracklier
cradler102910513cra_dler
crafter124111333cra_fter
crammer134010963cra_mmer
cramped144712183cramp_ed
crampiest15268623crampiest
cramping153411853cramping
crampit1338863crampi_t
crampits1436273crampits
cranker133612793cra_nker
crannied1137893crannied
crannies10313013crannies
crape96128443cra_p_e_
craped116120523cra_p_ed
crapes104727693cra_p_es
craping124018713cra_ping
crappy15446803crapp__y
crasher124616163cra_sher
crasser94114343cra_sser
crater85026643cra__ter
craver114618473cra__ver
crawler123510463cra_wler
crayoner1344863crayoner
crazies183413853cra_zies
creakier14328333creakier
creamier12319063creamier
creasier103210193creasier
creeper11339983creep_er
creepie1137483creepie_
creepies1239613creepies
crier74724463cr___ier
crimper136510423crimp_er
cripple13378583cripple_
crippled15336793crippled
cripplers15314993cripplers
cripples14298403cripples
crisper113511053crisp_er
croakier14436263croakier
cropped143812063cropp_ed
croppers143311483cropp_ers
cropping153210883cropping
crosier94116573cr_osier
croupiers1334653croupiers
crozier18369933cr_ozier
cruddier1244153cruddier
crumbier1456363crumbier
crummier1435603crummier
crumplier1543783crumplier
cruppers14317323crupp_ers
crustier10259533crustier
cupper124313863c_upp_er
dapper114016633_dapp_er
dippier123111393_dippier
draffier1574323draffier
draftier1285263draftier
draggier11135773draggier
draper94315693dra_p_er
drawlier12225253drawlier
dripper12349233dripp_er
droopier1145573droopier
dropper12329873dropp_er
flapper14359203flapp_er
floppier1554633floppier
frappe13286953frapp_e_
frapped15318853frapp_ed
frappes14328383frapp_es
frapping16348103frapping
frumpier1534173frumpier
gloppier1354673gloppier
grabbier13316653grabbier
grainier9218903grainier
grapple12378003grapple_
grappled14336093grappled
grapplers14274303grapplers
grapples13348123grapples
grasper10389793grasp_er
grassier9349283grassier
grazier173611133gra_zier
gripier103210323gr_ipier
gripper124410713gripp_er
grumpier1334803grumpier
hippier143212103_hippier
hoppier143110703_hoppier
knapper15387153knapp_er
lapper104319953_lapp_er
lippier112710573_lippier
loppier11369723_loppier
mapper124516093_mapp_er
napper103718283_napp_er
nappie104112263_nappie_
nappies114613403_nappies
nippier11319833_nippier
orangier947713orangier
pappies103214833_pappies
peppier10268323_peppier
preppie1058093preppie_
preppies1149693preppies
quippier2133773quippier
racier85120973_ra_cier
rainier71614263_rainier
rallier73816273_rallier
rammier112811023_rammier
randier83618473_randier
rangier83714353_rangier
raper74932753_ra_p_er
rapider1067903_rapider
rapiers95012873_ra_piers
rapped114122683_rapp_ed
rappee103618673_rapp_ee
rappees113611453_rappees
rappel104211953_rapp_el
rappen103512713_rapp_en
rappers113618443_rapp_ers
rapping123619103_rapping
rappini11347573_rappini
rasper83917333_rasp_er
rattier74015593_rattier
replier94214973_replier
ripper103518653_ripp_er
rippler113210103_rippler
ripplier1234463_ripplier
ropier84118803_r_opier
roupier9319493_roupier
sapper103822353_sapp_er
scraggier1344133scraggier
scraper114513423scra_p_er
scrapie115010943scra_pie_
scrapies124612483scra_pies
scrapped1556533scrapp_ed
scrappers1545863scrapp_ers
scrappiest1644163scrappiest
scrappily1842673scrappily
scrapping1635743scrapping
scrapple1434683scrapple_
scrapples1534803scrapples
scrawlier1443903scrawlier
scrawnier1443643scrawnier
scrimpier1554243scrimpier
slapper113512473slapp_er
slippier1256543slippier
sloppier1255713sloppier
snapper113512073snapp_er
snippier1255793snippier
soapier93411713soa_pier
soppier112711583_soppier
strapper1258093strapp_er
stroppier1364453stroppier
swampier1544593swampier
swapper14359703swapp_er
tapper104419613_tapp_er
tippier113210543_tippier
tramper113812163tramp_er
trampler12278013trampler
trapped124512213trapp_ed
trappers123711043trapp_ers
trapping132911393trapping
trashier113210103trashier
tripper113711923tripp_er
unhappier1642403unhappier
vampier14308233_vampier
waspier12259053_waspier
whapper17348273whapp_er
whippier18265823whippier
wrapped15338023wrapp_ed
wrappers15306933wrapp_ers
wrapping16297623wrapping
wrathier1435903wrathier
yapper133714513_yapp_er
zapper193414023_zapp_er
zippier20308193_zippier

Search took 10 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.423422437.4
2DLD Change Limit1461622898.65616885.6
3Display Results2892890.2331240.3
 (SQL Overall)1786912899.31219189.3
 
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.