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

206 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
crater8502664(None) 
carter84932271carter
cater74840721c_ater
coater84329571coater
crafter124111331crafter
crate76537401crate_
crated94827771crated
craters95021891craters
crates85736061crates
craver114618461craver
frater94520591frater
grater74625441grater
irater65218351irater
krater104014311krater
prater84825351prater
rater54943281_rater
abater85518122abater
barter85525372barter
beater84729392beater
boater84622092boater
bracer104620582bracer
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
caber95126832c_aber
cager85229222c_ager
caner75334772c_aner
canter85230112canter
caper94831622c_aper
carate84734002carate_
carates95630612carates
carder94524182carder
career85822242career
carer74942332c_arer
carper104923632carper
carte75940422carte_
carted98631442carted
cartel85022532cartel
carters95327252carters
cartes86239472cartes
carver114420142carver
caster85232572caster
cate66254602c_ate_
caters85336502c_aters
cates75951892c_ates
caver105629062c_aver
center84421412center
cerate84829462cerate_
cerated103922472cerated
cerates95428252cerates
chafer144714572chafer
chanter123919732chanter
chapter144213852chapter
charter123918302charter
chaser114918382chaser
chaster124718502chaster
chatter124416642chatter
chawer144314412chawer
cheater124816962cheater
citer74827332c_iter
clatter94014972clatter
claver113816972claver
clawer114512782clawer
coaler84121712coaler
coaster94219042coaster
coated94927042coated
coatee84327222coatee
coaters93525792coaters
coaxer153912792coaxer
colter84625092colter
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
couter84930222couter
crabber133810732crabber
cracker153114172cracker
cradler102910512cradler
crafted13419772crafted
crafters13419952crafters
craftier1376192craftier
crake114823522crake_
crakes124921812crakes
crammer134010962crammer
crane75331602crane_
craned96121652craned
cranes84330752cranes
cranker133612782cranker
crape96128442crape_
craped116120522craped
crapes104727692crapes
crapper133913192crapper
crases85532312crases
crasher124616162crasher
crasser94114332crasser
cratch134110792cratch
cratered1149682cratered
craton84517192craton
crave105626312crave_
craved125417772craved
craven114113932craven
cravers124416552cravers
craves115825392craves
crawler123510452crawler
craze165221462craze_
crazed184714452crazed
crazes174720132crazes
crazier183610742crazier
creamer113714082creamer
creaser94415722creaser
create85126372create_
created104323442created
creates95225192creates
creator93714432creator
crier74724462cr_ier
critter94113032critter
croaker133010682croaker
crofter12299572crofter
crower114117552crower
crozer175112842crozer
cruder95612382cruder
curate85226242curate_
curated104717582curated
curates95323832curates
curator9312212curator
curter85320082curter
cuter74728232c_uter
cutter84521002cutter
darter75320362darter
dater65332312_dater
drafter11449422drafter
draper94315692draper
drawer104711362drawer
eater54639842_eater
elater64724202elater
eraser64216332eraser
feater95224052feater
framer114817442framer
fraters103517212fraters
garter74420512garter
gater64533652_gater
grader84919692grader
grafter114211152grafter
granter84117132granter
grate64932882grate_
grated84523922grated
graters85419742graters
grates75429892grates
graver105018592graver
grayer106014542grayer
grazer164815762grazer
greater84416492greater
hater85034752_hater
heater94828302heater
irate55627982irate_
kraters114212342kraters
later54843922_later
mater74438862_mater
neater64424312neater
oater55433732_oater
orate55133302orate_
orated74221502orated
orates64328612orates
orator6314532orator
pater74740722_pater
plater84427692plater
prate75135982prate_
prated94924922prated
praters94921652praters
prates84633162prates
prayer114815292prayer
racer75233022_racer
rafter94517582_rafter
raker94529792_raker
ranter63826822_ranter
raper74932752_raper
rarer54731702_rarer
raser55633412_raser
raster64731442_raster
rate45458762_rate_
rated65441382_rated
ratel54224882_ratel
raters63936582_raters
rates55352012_rates
rather94319742_rather
ratter64326312_ratter
raver85631492_raver
rawer84623732_rawer
razer144824272_razer
scraper114513412scraper
seater64534152seater
skater105015492skater
slater64429182slater
stater64427562stater
tarter64023562tarter
tater54138612_tater
tracer84820232tracer
trader75218762trader
treater74219832treater
triter65120592triter
urate55432162urate_
urates65027762urates
ureter6313202ureter
water84733312_water
writer94416512writer

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 Filter178691825510.1101624463.6
2DLD Change Limit825512062.68630733.8
3Display Results2062060.0633269.8
 (SQL Overall)1786912062.85962501.2
 
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.