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

111 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
cellarer1031792(None) 
cellared11398791cellared
cellarers11236501cellarers
cellaret103713571cellaret
cellae84915932cella_e_
cellar84514982cella__r
cellarets11246062cellarets
cellars93713692cellar_s
clearer93710822c_learer
collared113211142collared
collaret103116702collaret
declarer1148062declarer
allayer10148213_allayer
allurer7348433_allurer
bearer85323913be__arer
belayer12339503be_layer
bellower13159063bellower
caller85125483call__er
calliper1247513calliper
callower13159073callower
carer74942333c___arer
ceiler84013963ceil__er
cella75420313cella___
cellarage1243563cellarage
cellarages1343463cellarages
cellarette1252483cellarette
cellaring1238523cellaring
cellarway1752193cellarway
celled94420323cell__ed
cellmate1237863cellmate_
cellmates1347513cellmates
cellular1045163cellular
cellule936523cellule_
cellules1036813cellules
censurer10228133censurer
centare93113703centare_
centares102913893centares
claret84026573c__laret
claver113816973c__laver
clawer114512783c__lawer
cleaner93712303c_leaner
cleared103612463c_leared
clearers10349303c_learers
cleaver124110803c_leaver
cleverer1334563cleverer
coleader1139173coleader
collage102813753collage_
collaged12279963collaged
collagen11338563collagen
collages113514233collages
collar83816173colla__r
collard103712923collar_d
collards113310193collards
collarets11327333collarets
collars93816573collar_s
collate92919683collate_
collated113615063collated
collates103019143collates
collator10310373collator
colleger11227923colleger
collider113410413collider
collier93618153coll_ier
colluder11276863colluder
colorer9312523c_olorer
colourer1037563colourer
comparer143611363comparer
culler84322253cull__er
dearer74822803de__arer
declare10411223declare_
declared1248743declared
declarers1236423declarers
declares11611313declares
deflater123211603deflater
delayer113010533de_layer
deplorer1136343deplorer
elater64724203_e_later
enlarger944153_enlarger
fearer94820183fe__arer
fellate10313433fellate_
fellated1239563fellated
fellates11312753fellates
fellator1176713fellator
feller94419553fell__er
hearer94323643he__arer
heller93322513hell__er
mellower13167403mellower
nearer64618893ne__arer
ocellar936533ocella__r
ocellate1037863ocellate_
ocellated1245453ocellated
pillager11278543pillager
pillared11228083pillared
rearer64928913re__arer
relater73723143re_later
relaxer143410223re_laxer
releaser839503releaser
reloader937913reloader
replacer12279743replacer
seafarer1144843seafarer
searer65432023se__arer
seller63824593sell__er
tearer64822903te__arer
teller63519813tell__er
villager12267503villager
vulgarer1243013vulgarer
wearer94319403we__arer
welfare1335713welfare_
welfares1445543welfares
welldoer1243473welldoer
yeller94214513yell__er
yellower14186213yellower

Search took 10 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.233766914.2
2DLD Change Limit1461621119.31315694.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911119.59218629.2
 
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.