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

523 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
crisper11351105(None) 
crimper136510421crimper
crisped124010101crisped
crispen11348201crispen
crispers12309431crispers
crispier12297251crispier
brisker134210292brisker
chipper163912582chipper
chirper14359962chirper
clasper113811862clasper
clipper133710322clipper
crapper133913192crapper
crasher124616152crasher
crasser94114332crasser
creeper11339972creeper
cribber13367662cribber
crier74724462cri__er
crimmer133310772crimmer
crimped143910762crimped
crimpers14318932crimpers
crimpier14287322crimpier
cringer103514242cringer
cripe95521142cri_pe_
cripes105120872cri_pes
crippler14826712crippler
crises84529432cris_es
crisp95014622crisp__
crispens12286252crispens
crispest12177372crispest
crisply14426522crisply
crisps104411512crisp_s
crispy13478562crisp_y
critter94113032critter
cropper133312962cropper
crosier94116572crosier
crosser95015462crosser
cruiser93410432cruis_er
crupper13338562crupper
crusher124412322crusher
dripper12349222dripper
frisker14389272frisker
grasper10389782grasper
griper94114612gri_per
gripper124410712gripper
grister83915412grister
lisper84114432_lisper
prosper114012182prosper
rasper83917322_rasper
riper74328402_ri_per
ripper103518652_ripper
riser55431052_ris_er
risker105414492_risker
scrimper1455752scrimper
tripper113711922tripper
whisper15298012whisper
acrider1038623acri_der
arider74717743ari_der
arise56436433aris_e_
arisen65316793aris_en
arises65233803aris_es
artsier768943artsier
aruspex1642543aruspex
asper75520433__asper
bister84922763_bister
blister94415313blister
brasher124515233brasher
brasier94516753brasier
briber104714043bri_ber
bridler103811073bridler
briefer1235563briefer
brier74527403bri__er
brimmer13348803brimmer
briner84519043bri_ner
bringer104213353bringer
brinier93613463brinier
brises84927613bris_es
brisked144210003brisked
brisket134413403brisket
brisses94314313brisses
bruiser9349573bruis_er
brusher123813003brusher
brusker13437853brusker
caliper11410963caliper
camper124722213c_amper
canister101710853canister
caper94831623c__aper
capper124421983c_apper
caresser1038803caresser
carper104923633c_arper
caster85232573c_aster
causer84117783caus_er
ceiler84013963cei_ler
censer84516583cens_er
cerise84822043ceris_e_
cerises94722253ceris_es
champer163813403champer
chaser114918383chas_er
chaster124718503chaster
cheaper144010583cheaper
cheeper143610743cheeper
cherisher1765233cherisher
chicer134513603chi_cer
chider125116053chi_der
chiefer1536863chiefer
chigger1436003chigger
chiller124112183chiller
chimer135517203chi_mer
chipped174110813chipped
chippers173510873chippers
chippier17297673chippier
chirker16429323chirker
chirped15379783chirped
chirpers15358133chirpers
chirpier15276303chirpier
chisel112111943chis_el
chiseler1335903chiseler
chitter124112963chitter
chomper163810073chomper
chopper163611893chopper
chorister1487143chorister
christen13106703christen
cider84723313c_i_der
cinder94119123c_inder
cipher133710263c_ipher
circler1136423circler
cisted95217523c_isted
cistern93310693c_istern
citer74827323c_i_ter
cither114616683c_ither
clamper134012993clamper
clapper134011863clapper
clasher124615513clasher
clasped123610443clasped
claspers124410913claspers
classer93614613classer
clicker154111883clicker
climber13449133climber
clinger103812143clinger
clinker133811663clinker
clipped14439833clipped
clippers14368833clippers
cloister1037093cloister
closer84918203clos_er
cluster94013323cluster
clyster12317453clyster
coaster94219033coaster
coiler84421593coi_ler
coiner84323783coi_ner
coinfer12419393coinfer
cointer93616723cointer
cooper104221123c_ooper
coper95336093c__oper
copper124321893c_opper
cosher114819903c_osher
cosier84423753c_osier
coster84331293c_oster
crabber133810733crabber
cracker153114173cracker
cradler102910503cradler
crafter124111333crafter
crammer134010963crammer
cramped144712183cramped
crampier14288903crampier
cranker133612783cranker
crape96128443cr_ape_
craped116120523cr_aped
crapes104727693cr_apes
crapped143912623crapped
crappers144011023crappers
crappier14288133crappier
crases85532313cras_es
crashed134214203crashed
crashers134013223crashers
crashes124618403crashes
crater85026633cr_ater
craver114618463cr_aver
crawler123510453crawler
crazier183610743crazier
creamer113714083creamer
creaser94415723creaser
creasier103210193creasier
creeped12329713creeped
creepers12318623creepers
creepier1236253creepier
crepe95520723cr_epe_
creped114115703cr_eped
crepes105419343cr_epes
crepey135110933cr_epey
crepier1139733crepier
cresses94219813cresses
cresset93319943cresset
crested103416533crested
cribbed14407663cribbed
cribbers14306443cribbers
cricked164814283cricked
cricket154716953cricket
crickey18418143crickey
cried84624283cri__ed
criers83918583cri__ers
cries75438403cri__es
crikey15317783cri_key
crime94822693cri_me_
crimes105521583cri_mes
crimmers14298543crimmers
crimp115615803crimp__
crimple13408693crimple
crimpled15366933crimpled
crimples14308963crimples
crimps124613453crimp_s
crimpy15489393crimp_y
cringe93515483cringe_
cringed113312403cringed
cringers112511873cringers
cringes103215503cringes
cripple13378583cripple
crippled15336793crippled
cripplers15314993cripplers
cripples14298403cripples
cris66233433cris___
crisic103611843cris_ic
crisis83716343cris_is
crispate1246913crispate
crispated1445023crispated
crispened1443613crispened
crisphead1742663crisphead
crispiest13197423crispiest
crispily1574693crispily
crisping13319663crisping
crispness1345303crispness
crissa837623cris_sa
crissal937413crissal
crissum1144843crissum
crista8311803cris_ta
cristae9310603cristae
critters103511313critters
crittur9315133crittur
croaker133010683croaker
crofter12299573crofter
crooker134111093crooker
crooner93714043crooner
cropped143812063cropped
croppers143311483croppers
crosiers103312053crosiers
crosse85216303crosse_
crossed105313893crossed
crossers103912693crossers
crosses94220793crosses
croupe105114433croupe_
croupes114613103croupes
croupier1246883croupier
crowder13389843crowder
crower114117553cr_ower
crowner124012593crowner
crozer175112843cr_ozer
crozier18369933crozier
cruder95612383cr_uder
crueler939023crueler
cruise84314043cruis_e_
cruised103710213cruis_ed
cruisers10438263cruis_ers
cruises93514443cruis_es
cruller968753cruller
crumber13339643crumber
crumped144311223crumped
crumpet133711063crumpet
cruppers14317313cruppers
crusader1144263crusader
cruse75726103crus_e_
cruses88127713crus_es
cruset84425093crus_et
crushed134111963crushed
crushers134010083crushers
crushes124215133crushes
crusted103712753crusted
crustier10259533crustier
cuishes122810823cuishes
cuisse8318333cuisse_
cuisses9319883cuisses
cupper124313863c_upper
curser84721473curs_er
cusped114312043c_usped
cusser86016093c_usser
diaper94513113_diaper
dipper114017783_dipper
dispel9310323_dispel
draper94315693dr_aper
dresser83611953dresser
drier64423963dri__er
drifter11348703drifter
driller84311883driller
drinker12349473drinker
dripped13408083dripped
drippers13327933drippers
drippier1385043drippier
driver104714493dri_ver
dropper12329873dropper
eclipser1242793eclipser
eraser64216333eras_er
fisher124917143_fisher
flipper14389143flipper
fresher132612643fresher
frier85225843fri__er
friller104111743friller
frippery1832953frippery
frisbee12298513frisbee
frise85322453fris_e_
frisee94217993fris_ee
frisees104411693frisees
frises94124273fris_es
friseur1033673friseur
frisked15478823frisked
friskers15337373friskers
frisket143811773frisket
friskier1535193friskier
fritter103912773fritter
frizer184011283fri_zer
frizzer18446893frizzer
gasper94515543_gasper
gipper114215303_gipper
glister84013343glister
grasped11409063grasped
graspers11338393graspers
gridder10367763gridder
griever1136033griever
grifter113810493grifter
griller84513353griller
grimier103210433grimier
grimmer123510093grimmer
grinder93312393grinder
grinner8329233grinner
gripe84622963gri_pe_
griped104114713gri_ped
gripers104011463gri_pers
gripes94619873gri_pes
gripey124111203gri_pey
gripier103210323gripier
grippe115310323grippe_
gripped13419343gripped
grippers13358123grippers
grippes124810373grippes
grippier1355203grippier
grislier935793grislier
gristers94013403gristers
gritter83913353gritter
groper94517253gr_oper
grosser84313143grosser
grouper104210093grouper
heister103613623heister
hipper133818023_hipper
hisser94713793_hisser
hoister103714203hoister
irised73913153iris_ed
irises64221173iris_es
jasper154610383_jasper
jimper17389863_jimper
kaiser103610373kais_er
keister113011573keister
kipper143414203_kipper
kisser104212453_kisser
klister113410643klister
krimmer15376873krimmer
krises105016083kris_es
leister73212753leister
limper104117853_limper
lipper104219633_lipper
lisped94113423_lisped
lispers94514323_lispers
lister64527253_lister
meister93114163meister
miser75430403_mis_er
mispen10312173_mispen
mister84728563_mister
moister94015373moister
nipper103715713_nipper
noisier759453noisier
piper96523193_pi_per
pisher114317753_pisher
pisser84416383_pisser
poiser84217243pois_er
praiser93413943prais_er
presser93717623presser
prester93519623prester
pricer103918293pri_cer
pricier113313113pricier
pricker154013413pricker
prier75027763pri__er
primer105118683pri_mer
primmer134310163primmer
primped14479153primped
prinker133412743prinker
printer93917303printer
prise74632613pris_e_
prised94322203pris_ed
prisere9310943pris_ere
prises84133173pris_es
prisoner1048573prisoner
prissed103311263prissed
prisses94816713prisses
prissier10157873prissier
privier122910453privier
prizer174714883pri_zer
proper104319953pr_oper
proser84223463pros_er
prosier93817483prosier
prospers123012253prospers
quipper2095813quipper
raiser66620103rais_er
raper74932753_r_aper
rapper104621573_rapper
raser55633413_ras_er
rasher95024113_rasher
rasped94715203_rasped
raspers94415913_raspers
raspier93110633_raspier
raster64731443_raster
reaper84223143_reaper
rester63832433_rester
ribber103515493_ribber
ribier84414223_ribier
ricer74726613_ri_cer
richer114015043_richer
ridder84015143_ridder
rider65231303_ri_der
riever94811653_riever
rifer84721983_ri_fer
rifler94014263_rifler
rigger85616713_rigger
rimer75429243_ri_mer
rimier83916263_rimier
rimmer103516033_rimmer
ringer74526053_ringer
rinser64317213_rinser
rioter64817283_rioter
ripe66038923_ri_pe_
riped85226433_ri_ped
ripen75619263_ri_pen
ripes75435773_ri_pes
ripped114419013_ripped
rippers114115023_rippers
rippler113210103_rippler
rise45945233_ris_e_
risen54621883_ris_en
risers64624783_ris_ers
rises55244043_ris_es
risked115514633_risked
riskers114011993_riskers
riskier1138423_riskier
ritter63822413_ritter
river85731693_ri_ver
roister73516203roister
romper104213683_romper
roper75431913_r_oper
rosier64221263_rosier
roster64329083_roster
rusher94019653_rusher
scraper114513403scr_aper
scrapper1466953scrapper
scriber113910963scri_ber
scrimped1555313scrimped
scrimpers1554633scrimpers
scrimpier1554243scrimpier
scripter12137773scripter
seiser65318343seis_er
shipper143514033shipper
shrimper1544413shrimper
simper103616293_simper
sipper103920983_sipper
sister64421583_sister
skipper15339563skipper
slipper113712973slipper
sniper84413643sni_per
snipper113911323snipper
striper94514783stri_per
stripper1247113stripper
swisher13369523swisher
tipper103918413_tipper
tramper113812153tramper
trapper113912793trapper
trasher104416123trasher
tricker134615523tricker
trier54328533tri__er
trifler103912153trifler
trigger9329153trigger
triller74215893triller
trimer85717153tri_mer
trimmer113610833trimmer
tripe75425383tri_pe_
tripes85324873tri_pes
tripped123911693tripped
trippers123210153trippers
trippet113714113trippet
trippier1246623trippier
triste63818643triste_
triter65120593tri_ter
trooper94210353trooper
trouper93811413trouper
trusser74010253trusser
truster73114313truster
tryster10369513tryster
twister10308953twister
unriper9188283unri_per
upriser9218763upris_er
vesper1138083_vesper
viper105017303_vi_per
waister103812383waister
whimper17297723whimper
whipper173611383whipper
whisker17367933whisker
whispers16266993whispers
whispery19284293whispery
wiper105421293_wi_per
wiser85522803_wis_er
wisher123617063_wisher
wisped123411893_wisped
wispier12249403_wispier
wrapper14368333wrapper
wrester102812413wrester
wrier84521753wri__er
wringer113612453wringer
wristier1136863wristier
writer94416513wri_ter
writher134010853writher
zipper193813123_zipper

Search took 9 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.1561145455.1
2DLD Change Limit1340275237.68617437.8
3Display Results5235230.1862811.8
 (SQL Overall)1786915238.02822258.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.