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

321 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
crampier1428890(None) 
campier133313271c_ampier
crappier14288131crappier
crimpier14287321crimpier
trampier12318241trampier
camper124722212c_amp_er
champer163813412champ_er
clammier1435842clammier
clamper134012992clamp_er
clumpier1435582clumpier
crabbier14326802crabbier
craftier1376192craftier
craggier12116062craggier
crammer134010962cram_mer
cramped144712182cramp_ed
crampiest15268622crampiest
cramping153411852cramping
crampit1338862crampi_t
crampits1436272crampits
crankier14339162crankier
crapper133913192cra_pper
crappie13298982crappie_
crappies142911162crappies
crawlier13216872crawlier
crazier183610742cra_zier
creamier12319062cream_ier
creepier1236252creepier
crepier1139742cr_epier
crimper136510422crimp_er
crispier12297252crispier
croupier1246882croupier
crumbier1456362crumbier
crummier1435602crummier
crumplier1543782crumplier
frumpier1534172frumpier
grapier103712602gra_pier
grumpier1334802grumpier
rammier112811022_rammier
rapier84019992_ra_pier
raspier93110642_raspier
scrappier1544432scrappier
scrimpier1554242scrimpier
swampier1544592swampier
tramper113812162tramp_er
trampler12278012trampler
vampier14308232_vampier
ampler104313303__ampler
barmier114313043barm_ier
beamier113411943beam_ier
braggier12136453braggier
brainier102510233brainier
brakier133812363bra_kier
bramblier1543503bramblier
brannier10218933brannier
brashier13389933brashier
brasier94516753bra_sier
brassier103310533brassier
brattier1047663brattier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473bra_zier
bumpier13359203_bumpier
cagier93715933c_a_gier
cahier113615773c_a_hier
cakier123115243c_a_kier
caliper11410963c_aliper
camber124418483c_am_ber
cammie124615293c_ammie_
cammies134016483c_ammies
camped134720233c_amp_ed
campers134220293c_amp_ers
campfire1744023c_ampfire
camphire1745893c_amphire
camphor1636133c_amphor
campi116217783c_ampi__
campiest142212143c_ampiest
campily1638273c_ampily
camping143118973c_amping
campion133011413c_ampion
cannier94014163c_annier
caper94831623c_a_p_er
capper124421983c_a_pper
carmaker1637313carmaker
carper104923633c_arp_er
carrier93619583c_arrier
cashier123713323c_ashier
cattier93317073c_attier
chaffier1935473chaffier
chalkier1736753chalkier
chamber164011063cham_ber
chamfer17399863cham_fer
chammied18215973chammied
chammies172910163chammies
champed174111483champ_ed
champers173311623champ_ers
champing183610933champing
champion17276353champion
chancier1538823chancier
chapiter1536603cha_piter
chappie16298663chappie_
chappies172610103chappies
chapter144213853cha_pter
charier124317903cha_rier
charrier1378683charrier
chattier1337513chattier
chippier17297673chippier
chirpier15276303chirpier
chomper163810073chomp_er
choppier17286643choppier
chromier1538033chrom_ier
chummier1734513chummier
clamber133311743clam_ber
clammer134211793clam_mer
clamorer1236913clamorer
clamped144012043clamp_ed
clampers143211893clamp_ers
clamping154011153clamping
clankier14327083clankier
clapper134011863cla_pper
clasper113811863clasp_er
classier10359083classier
clavier1239173cla_vier
clayier1248323cla_yier
clumsier1234733clumsier
coalier93416183coa_lier
comfier1439163c_omfier
compeer133811553c_ompeer
compiler1438373c_ompiler
complier14310253c_omplier
copier103722893c__opier
crabber133810733cra_bber
cracker153114173cra_cker
cracklier1744823cracklier
cradler102910513cra_dler
crafter124111333cra_fter
crambe1239073cram_be_
crambes1339963cram_bes
cramboes1436543cramboes
crammed143710123cram_med
crammers14369353cram_mers
cramming15339433cramming
cramoisy1543703cramoisy
cramp115120693cramp___
crampfish2142593crampfish
crampon1336943cramp_on
crampons1436643crampons
crampoon1444543crampoon
cramps125615563cramp__s
crampy154710993cramp__y
cranker133612793cra_nker
crannied1137893crannied
crannies10313013crannies
crape96128443cra_p_e_
craped116120523cra_p_ed
crapes104727693cra_p_es
craping124018713cra_ping
crapped143912623cra_pped
crappers144011023cra_ppers
crappiest15267273crappiest
crapping153911453crapping
crasher124616163cra_sher
crasser94114343cra_sser
crater85026643cra__ter
craver114618473cra__ver
crawler123510463cra_wler
crayoner1344863crayoner
crazies183413853cra_zies
creakier14328333creakier
creamer113714093cream__er
creasier103210193creasier
creeper11339983creep_er
creepie1137483creepie_
creepies1239613creepies
crier74724463cr___ier
crimmer133310773crim_mer
crimped143910763crimp_ed
crimpers14318933crimp_ers
crimpiest15237183crimpiest
crimping15299783crimping
crimple13408693crimple_
crimpled15366933crimpled
crimples14308963crimples
crippler14826713crippler
crisper113511053crisp_er
croakier14436263croakier
cropper133312963cr_opper
croppie13278793croppie_
croppies143111133croppies
crosier94116573cr_osier
croupiers1334653croupiers
crozier18369933cr_ozier
cruddier1244153cruddier
crumber13339643crum_ber
crumblier1543873crumblier
crummie1336153crummie_
crummies1437643crummies
crumped144311223crump_ed
crumpet133711063crump_et
crumping15319903crumping
crumple13368363crumple_
crumpled15296873crumpled
crumples14348813crumples
crupper13338563cr_upper
crustier10259533crustier
cuppier1368323c_uppier
damper114117753_damp_er
draffier1574323draffier
draftier1285263draftier
draggier11135773draggier
draper94315693dra_p_er
drawlier12225253drawlier
dreamier11287293dream_ier
drippier1385043drippier
droopier1145573droopier
drumlier1134523drumlier
dumpier12409653_dumpier
flamier123112143flam_ier
flappier1544303flappier
foamier12339003foam_ier
framer114817443fram__er
gambier124711973_gambier
gamier93617933_gam_ier
gammier123711193_gammier
gappier12369843_gappier
gimpier12247943_gimpier
glumpier1334873glumpier
grabbier13316653grabbier
grainier9218903grainier
grappler13336193grappler
grasper10389793grasp_er
grassier9349283grassier
grazier173611133gra_zier
grimier103210433grim_ier
gripier103210323gr_ipier
grippier1355203grippier
hammier143510653_hammier
hamper134518653_hamp_er
happier143312043_happier
hempier14319003_hempier
humpier143110723_humpier
jammier18408023_jammier
jumpier18317943_jumpier
lambier113611643_lambier
loamier9349163loam_ier
lumpier113410143_lumpier
nappier114411173_nappier
orangier947713orangier
pamper124316663_pamp_er
pappier103511603_pappier
premier113515633prem_ier
preppier1156643preppier
prompter1437983prompter
racier85120973_ra_cier
rainier71614263_rainier
rallier73816273_rallier
rambler113313263_rambler
ramie75027823_ram_ie_
ramies84630463_ram_ies
rammer103519653_ram_mer
rampager1344453_rampager
ramped114617903_ramp_ed
rampike1536603_rampike
rampikes1635393_rampikes
ramping123316873_ramping
rampion11298583_rampion
randier83618473_randier
rangier83714353_rangier
raper74932753_ra_p_er
rapider1067903_ra_pider
rapiers95012873_ra_piers
rapper104621573_ra_pper
rasper83917333_rasp_er
rattier74015593_rattier
rimier83916273_rim_ier
romper104213683_romp_er
ropier84118803_r_opier
roupier9319493_roupier
rummier11309563_rummier
rumplier1235303_rumplier
sampler113212013_sampler
sappier113613123_sappier
scamper134613163scamp_er
scampies1439333scampies
scraggier1344133scraggier
scrambler15165043scrambler
scraper114513423scra_p_er
scrapie115010943scra_pie_
scrapies124612483scra_pies
scrapper1466973scra_pper
scrawlier1443903scrawlier
scrawnier1443643scrawnier
scrimper1455763scrimp_er
seamier93114633seam_ier
shrimpier1643063shrimpier
skimpier1634293skimpier
snappier1266223snappier
soapier93411713soa_pier
stamper113714403stamp_er
strappier1345143strappier
stumpier1255883stumpier
swamper14349313swamp_er
tamper104618513_tamp_er
tramped124312433tramp_ed
trampers123210393tramp_ers
trampiest13227903trampiest
tramping132711273tramping
trampish1535653trampish
trample11299703trample_
trampled13247903trampled
tramplers13305883tramplers
tramples122610203tramples
trapper113912803tra_pper
trashier113210103trashier
trippier1246623trippier
vamper134212653_vamp_er
vampire14296673_vampire
waspier12259053_waspier
wimpier14248053_wimpier
wrapper14368333wra_pper
wrathier1435903wrathier
zappier20458373_zappier

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.403443402.0
2DLD Change Limit1461623216.78321548.3
3Display Results3213210.1232609.8
 (SQL Overall)1786913217.30924448.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.