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

147 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
camailed133655(None) 
availed1135972_availed
caballed1337162caballed
camail10314832camail__
camails11311752camail_s
canaled103615562cana_led
canalled1139582canalled
caviled1348722ca_viled
compiled1537812compiled
emailed10359212_emailed
mailed95326752__mailed
remailed112411402remailed
unmailed11229762unmailed
ailed66240283___ailed
airmailed1242903airmailed
amassed10388633_amassed
amazed18519313_ama_zed
ambled115116373_am_bled
anviled1138953_anviled
ariled75620323_a_riled
assailed945323assailed
awaited1146963_awaited
bailed94726653__bailed
bewailed1435343bewailed
brailed103914013_brailed
cabined1239993ca_bined
cabled114819873c__abled
cackled164613303ca_ckled
caddied123710563caddi_ed
caddised13315893caddised
cajoled17428283ca_joled
calamined1447433calamined
calcined1338743calcined
called94126733c__alled
camarilla1374043camarilla
camases114216343cama_ses
camasses12388973camasses
cambered15129003cambered
camelid1249413cam_elid
cameoed1238383cam_eoed
camise103319633cam_ise_
camises114218463cam_ises
camlet104426583cam__let
cammie124615293cammi_e_
cammies134016483cammi_es
camomile14156323camomile_
camomiles15155633camomiles
campaigned1842153campaigned
campanile1544403campanile_
campaniles1644113campaniles
camped134720233cam__ped
campier133313273campi_er
campily1638273campil_y
campused1535253campused
canaille1048413canaille
canailles1148273canailles
canalised12810913canalised
canalized21611693canalized
canaller1038953canaller
canceled13279403canceled
candied113816023candi_ed
candled113815743ca_ndled
canfield1444333canfield
capable13313363capable_
capabler1435353capabler
caprioled1464743caprioled
capsized2255493capsized
capsuled1334533capsuled
captained1446193captained
caracoled1445993caracoled
caried94528693ca_ri_ed
caroled103717693ca_roled
carolled1138833carolled
carried103717153carri_ed
castled104311513ca_stled
catcalled1444893catcalled
cavalier1348183cavalier
caviler1249063ca_viler
cavilled1436733cavilled
ceiled94114953c__eiled
chained133812693c_hained
chaired134211243c_haired
chammied18215973chammi_ed
chamoised17335323chamoised
claimed12298833c_laimed
coaled95022713c_oa_led
coiled95123943c__oiled
combined15269183combined
commixed2264743commixed
compile13312443compile_
compiler1438373compiler
compiles14311983compiles
complied1539673complied
craaled10339423c_raaled
cradled113410813c_radled
crawled133710403c_rawled
curtailed1244113curtailed
damaged1257463dama_ged
damasked1643753damasked
derailed102410403derailed
detailed10319873detailed
entailed989523entailed
failed105421603__failed
fantailed1345563fantailed
flailed1137303_flailed
gambled134112163gam_bled
gamboled1435873gamboled
hailed104122743__hailed
jailed144917423__jailed
macled116718113__macled
maile75232223__maile_
mailer84724183__mailer
mailes84329113__mailes
maimed114812663__maimed
malled94626113__malled
manacled1336453manacled
marled95523163__marled
mauled94817823__mauled
moiled94318863__moiled
nailed74021493__nailed
namable11312343namable_
pantiled113111593pantiled
quailed1737823_quailed
railed74727543__railed
rambled123913523ram_bled
rattailed1084213rattailed
reavailed1344003reavailed
remained112412893remained
renailed92512803renailed
resailed93613063resailed
retailed94113963retailed
sailed74327763__sailed
sampled123410793sam_pled
smiled93716433_sm_iled
snailed83811923_snailed
tailed74424663__tailed
tamable11312853tamable_
tamale83717403tama_le_
tamales93216153tama_les
trailed83415673_trailed
travailed1344223travailed
unhailed12219963unhailed
unnailed9229443unnailed
vailed104619293__vailed
wailed104823593__wailed
wambled153610753wam_bled
wassailed1343153wassailed

Search took 9 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.423422437.4
2DLD Change Limit1461621477.79618748.3
3Display Results1471470.0632333.3
 (SQL Overall)1786911478.28221575.8
 
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.