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 “crenelled” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
crenelled124540(None) 
creneled11326891crene_led
crenelle1046331crenelle_
crenelles1146731crenelles
creeled104012012cre_e_led
crenelated1375362crenelated
crenellated1452522crenellated
kernelled1443742kernelled
rebelled113110332_rebelled
refelled122810172_refelled
repelled113111592_repelled
revelled123712742_revelled
bevelled14327823_bevelled
canalled1139583c_analled
cancelled1456743cancelled
celled94420323c___elled
chandelled1744273chandelled
channelled1644143channelled
cheerled14105713che_erled
chenille1354593chenille_
chenilles1444373chenilles
chiselled1544223chiselled
compelled1646133compelled
corbelled1446613corbelled
cordelled1346403cordelled
counselled1344533counselled
crankled15408153cran_kled
creeped12329713cre_e_ped
creeshed1435703cre_eshed
crenated113013913cren_ated
crenel84213063crene_l__
crenelate1176513crenelate
crenelates1266193crenelates
creneling1247733creneling
crenelling1345683crenelling
crenels93711013crene_l_s
crenulated1356043crenulated
crevalle1346163crevalle_
crevalles1455723crevalles
crinkled15357153crin_kled
crueller1056453cr_ueller
cudgelled1443113cudgelled
cupelled1365743c_upelled
drivelled1443983drivelled
farewelled1742373farewelled
ferrelled1343943ferrelled
funnelled1374233funnelled
gravelled1475553gravelled
grovelled1454183grovelled
gruelled1034893gr_uelled
jewelled1934343_jewelled
kennelled1443513kennelled
kerneled1344033kerne_led
knelled12338993__knelled
levelled12327453_levelled
panelled1138963_panelled
prebilled1445063prebilled
prefilled1535513prefilled
propelled1456913propelled
prunelle1044983prunelle_
prunelles1145073prunelles
quenelle1743713quenelle_
quenelles1843983quenelles
ravelled12419783_ravelled
rebilled11318053_rebilled
recalled11310803_recalled
reeled74725533_re_e_led
refilled12278673_refilled
refuelled1364513_refuelled
reheeled1236773_reheeled
remelted11310153_remelted
renailed92512803_renailed
reneged92010763_rene_ged
renested92212953_renested
renewed11309993_rene_wed
repanelled1343403_repanelled
repealed113211873_repealed
repeller103010403_repeller
repolled11359623_repolled
rerolled93010063_rerolled
resealed92713973_resealed
reseller83412253_reseller
respelled1257073_respelled
revealed123211213_revealed
reveled113917753_reve_led
reveller112912193_reveller
rewelded1335893_rewelded
rowelled1236633_rowelled
snelled83313053__snelled
tramelled1266223tramelled
travelled1356863travelled
trowelled1344443trowelled
tunnelled1054583tunnelled

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 Filter1786911486410.420425454.8
2DLD Change Limit148641938.79616898.7
3Display Results93930.0332818.2
 (SQL Overall)178691939.24919320.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.