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

123 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
camels10521708(None) 
camel96822801camel_
cameos105818001cameos
cames97047311came_s
acmes96020652acme_s
amens75624842_amens
amyls104512692_amyls
axels126313632_axels
babels105216722babels
bagels95712312bagels
cabals104020152cabals
cabers105023922cabers
cables104527552cables
cades85440732cade_s
cadets96316512cadets
cafes106426922cafe_s
cagers95624192cagers
cages85936012cage_s
cakes116037672cake_s
calls75634732ca_lls
calomels1236132calomels
camails11311752camails
camas96333522cam_as
camass104114182camass
cambers134017442cambers
came87648752came__
camelia11510432camelia
camelias12510302camelias
camelid1249412camelid
camelids1356942camelids
cameo95924992came_o
camera10313692camera
cameras11313362cameras
camlet104426582camlet
camlets114314622camlets
camos95927612cam_os
campers134220292campers
campos125217952campos
camps116330262cam_ps
campus125213922campus
cams87047282cam__s
canals84421672canals
cancels114113312cancels
caners84629202caners
canes75350372cane_s
cannels93413362cannels
capers105428142capers
capes95441922cape_s
caramels1238802caramels
carcels114516062carcels
carers85133962carers
cares77369182care_s
caress85720262caress
carets85330772carets
carles85435082carles
carls77037422ca_rls
carols85124982carols
carpels115315462carpels
carrels95117302carrels
cartels94618122cartels
carvels124914592carvels
cases75048382case_s
caters85336502caters
cates75951892cate_s
caules85927252caules
cauls75727772ca_uls
cavers115026842cavers
caves105639702cave_s
cavils114014392cavils
cels65534972c__els
chapels14429152chapels
chiels115115932chiels
comely134213732comely
comers105328082comers
comes97246992come_s
comets105823582comets
compels133210882compels
cormels113813372cormels
creels84416942creels
cupels10310202cupels
cymes1210118922cyme_s
cymols1377192cymols
dames85435852dame_s
damsels10126702damsels
easels65914552easels
enamels9128162enamels
fames105735922fame_s
gamely124711912gamely
gamers94420832gamers
games86238552game_s
gavels105911092gavels
gimels938892gimels
hamals114816822hamals
hames106138702hame_s
hazels185710082hazels
kames115024692kame_s
labels84515682labels
lameds94812032lameds
lamely114013222lamely
lames75445542lame_s
lapels83712042lapels
mameys13449522mameys
mels65941532__mels
namely113711322namely
namers84517332namers
names74833362name_s
navels95712692navels
panels84716522panels
ramees84620892ramees
ramets83517392ramets
ratels64518212ratels
ravels94717072ravels
sameks12409322sameks
samiels939762samiels
taels56822072ta_els
tamals84116632tamals
tamely113711952tamely
tamers84224032tamers
tames75242012tame_s
tramels93812492tramels
wadmels1334302wadmels
wames106432802wame_s
yamens114010822yamens

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.343520965.0
2DLD Change Limit825511232.39334496.9
3Display Results1231230.0602050.0
 (SQL Overall)1786911232.79663909.5
 
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.