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

203 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
ratel5422488(None) 
artel56122741artel
ratal55025111ratal
rate45458761rate_
rated65441381rated
ratels64518211ratels
rater54943281rater
rates55352011rates
ravel84621511ravel
ariel55228972ariel
artal55525472artal
artels66216232artels
ate37059242_ate_
ates45047922_ates
axel115222072_axel
babel95821692babel
bagel85116792bagel
bate66552422bate_
bated85935532bated
bates75846342bates
betel74419902betel
boatel84314092boatel
botel75121862botel
camel96822802camel
cartel85022532cartel
cate66254602cate_
cater74840722cater
cates75951892cates
crate76537402crate_
crated94827772crated
crater85026642crater
crates85736062crates
date56443322date_
dated75530992dated
dater65332312dater
dates65639152dates
easel54521112easel
eaten55323052eaten
eater54639842eater
fatal84819372fatal
fate75444282fate_
fated95632132fated
fates85139232fates
frater94520592frater
gate55746572gate_
gated75329772gated
gater64533652gater
gates65939512gates
gavel95815182gavel
grate64932882grate_
grated84523922grated
grater74625442grater
grates75429892grates
gravel105313822gravel
hate78450172hate_
hated95734022hated
hater85034752hater
hates86742572hates
hazel176414812hazel
hotel85520752hotel
irate55627982irate_
irately1047682irately
irater65218352irater
krater104014312krater
label75019382label
lapel73716682lapel
late47560482late_
lated65240672lated
lately93413842lately
laten54328342laten
later54843922later
latex124717112latex
mantel84317972mantel
mate65154222mate_
mated85537782mated
mater74438862mater
mates75251362mates
matey107022662matey
motel76623242motel
natal53921492natal
nates55238332nates
navel87016572navel
oaten55222402oaten
oater55433732oater
orate55133302orate_
orated74221502orated
orates64328612orates
panel76023622panel
pastel85918712pastel
pate65350462pate_
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
prate75135982prate_
prated94924922prated
prater84825352prater
prates84633162prates
race66746262race_
raced87635312raced
racer75233022racer
races74943242races
rafted104714702rafted
rafter94517582rafter
rage55742352rage_
raged74829452raged
ragee65432662ragee
rages64539442rages
rail46147762ra_il
rajes125022782rajes
rake84841572rake_
raked105831422raked
rakee96031172rakee
raker94529792raker
rakes94440352rakes
rale45050562rale_
rales54947492rales
ramal74622242ramal
ramee74633852ramee
ramen75625192ramen
ramet75743142ramet
ramtil8311022ramtil
ranee55438102ranee
ranted74324702ranted
ranter63826822ranter
rape65041632rape_
raped85334622raped
raper74932752raper
rapes75740722rapes
rappel104211952rappel
rare45348432rare_
rared65738322rared
rarely93513652rarely
rarer54731702rarer
rares55247442rares
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
raster64731442raster
rat37892742rat__
ratals64219582ratals
ratan53722662ratan
ratch104221362ratch
raters63936582raters
rath76037662rat_h
rathe85821922rathe
rather94319742rather
ratio55227582ratio
rato45436972rat_o
ratos55528762ratos
rats46260372rat_s
ratted74923342ratted
ratten64217382ratten
ratter64326312ratter
rattle64717612rattle
rattly94111542rattly
ratty84819592ratty
rave75542092rave_
raved94931432raved
ravels94717072ravels
raven84723442raven
raver85631492raver
raves85441972raves
rawer84623732rawer
raxed135622662raxed
raxes124729392raxes
rayed95127502rayed
raze135235432raze_
razed155027982razed
razee145827802razee
razer144824272razer
razes145032702razes
rebel73421292rebel
reel45240532r_eel
refel84920812refel
repel74921402repel
rete44944132rete_
retell63813642retell
retem74221952retem
revel84423162revel
riel46432382r_iel
rite45849452rite_
rites54442552rites
rote46249022rote_
rotes56143902rotes
rotl45029682rot_l
rowel84721412rowel
rubel75416832rubel
sate45556102sate_
sated66238532sated
satem76021462satem
sates54949322sates
tael46030712ta_el
tate44748602tate_
tater54138612tater
tates55444982tates
tel35647902__tel
tramel84113712tramel
travel94112982travel
urate55432162urate_
urates65027762urates
water84733312water

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.326548131.9
2DLD Change Limit538002031.76630464.3
3Display Results2032030.0603383.3
 (SQL Overall)1786912032.15283034.9
 
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.