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 “crier” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

215 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
crier7472446(None) 
brier74527401brier
cried84624291cried
criers83918581criers
cries75438401cries
drier64423961drier
frier85225841frier
prier75027761prier
trier54328531trier
wrier84521751wrier
achier113914262achier
acrider1038622acrider
aerier64823152aerier
airer54927892airer
airier64619362airier
arider74717742arider
ariel55228972ariel
armer76924442armer
artier63419732artier
bier65531832_bier
briar75718152briar
briber104714052briber
brie65837902brie_
brief105422602brief
briers85319732briers
briery114510772briery
bries74942152bries
briner84519042briner
burier84324652burier
caber95126832caber
cager85229222cager
cagier93715932cagier
cahier113615772cahier
cakier123115242cakier
caner75334772caner
caper94831622caper
carder94524182carder
career85822242career
carer74942332carer
caried94528692caried
caries85147622caries
carper104923632carper
carrier93619582carrier
carter84932272carter
carver114420152carver
cater74840722cater
caver105629062caver
ceder85322242ceder
ceiler84013962ceiler
charier124317902charier
cheer105420382cheer
chicer134513602chicer
chider125116052chider
chief134419482chief
chiel104918972chiel
chimer135517202chimer
chirr105015902chirr
cider84723312cider
cire65836372cire_
cires74932912cires
citer74827332citer
coder86134222coder
coiler84421592coiler
coiner84323782coiner
coir66327242coi_r
comer95832692comer
cooer74831012cooer
coper95336092coper
copier103722902copier
corder94322882corder
corer75538872corer
corker124720852corker
corkier133114302corkier
corner84625622corner
cornier93017092cornier
cosier84423762cosier
courier93617892courier
cover105430772cover
cower104531772cower
cowier113616162cowier
coyer105222842coyer
cozier173315142cozier
crater85026642crater
craver114618472craver
crazier183610742crazier
cred76530882cr_ed
creed85727392creed
creek114917392creek
creel75121482creel
creep95218102creep
crepier1139752crepier
crew96122682cr_ew
crib86323582cri_b
cribber13367662cribber
cribs94516752cribs
crick135118752crick
crikey15317782crikey
crime94822692crime
crimes105521582crimes
crimmer133310772crimmer
crimp115615802crimp
crimper136510422crimper
cringer103514242cringer
cripe95521142cripe
cripes105120872cripes
cris66233432cri_s
crises84529432crises
crisp95014622crisp
crisper113511052crisper
crit65743712cri_t
crits75527572crits
critter94113032critter
crore74922872crore
crosier94116582crosier
crower114117562crower
crozer175112842crozer
crozier18369942crozier
cruder95612382cruder
cruel74815902cruel
cruet74831842cruet
cruiser93410432cruiser
cruor7310452cruor
cuber95222532cuber
curber104517052curber
curdier103312622curdier
curer75030752curer
curie74533042curie_
curies84934022curies
curler85221322curler
curlier93314182curlier
currier93316702currier
curser84721472curser
curter85320082curter
curvier123110662curvier
cuter74728232cuter
cyber124910382cyber
cyder114611132cyder
decrier102713562decrier
direr64927072direr
dried75321382dried
driers74516732driers
dries64733672dries
driver104714492driver
dryer95111462dryer
eerier64320022eerier
firer811229252firer
flier86023402flier
freer86021242freer
friar85414272friar
fried95322912fried
friers94718932friers
fries85535602fries
frizer184011282frizer
fryer115913432fryer
gorier73719372gorier
grief95319782grief
griper94114612griper
hirer85423122hirer
icier74313752icier
ickier12439922ickier
kier86526812_kier
lier45942462_lier
mirier83918362mirier
orbier839992orbier
order65019362order
oriel54920422oriel
ormer75218372ormer
osier53518012osier
pier66035292_pier
plier75221282plier
pricer103918292pricer
pried84426862pried
priers84521192priers
pries74339532pries
primer105118682primer
prior74316172prior
prizer174714882prizer
pryer104415312pryer
ricer74726612_ricer
rider65231302_rider
riel46432382_riel
rifer84721982_rifer
rimer75429242_rimer
riper74328402_riper
riser55431052_riser
river85731692_river
ruer46127562_ruer
scarier94017872scarier
scriber113910972scriber
scried95817312scried
scries85226822scries
shier85428942shier
skier95119592skier
slier54827242slier
spier75728032spier
sprier84119062sprier
tier44936142_tier
tried65026912tried
triers64321522triers
tries55742812tries
trimer85717152trimer
triter65120592triter
truer54916642truer
twier84713292twier
urger64116472urger
varier94619352varier
verier94620962verier
vier75428152_vier
warier93722892warier
wirer85124952wirer
wirier94215552wirier
wried95518562wried
wries85827742wries
writer94416512writer
wryer11489302wryer

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538002152.03026502.5
3Display Results2152150.0633412.7
 (SQL Overall)1786912152.38974797.4
 
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.