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

149 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
crustily1332817(None) 
crusily12199091crus_ily
rustily103112991_rustily
trustily11257101trustily
chestily1645522chestily
craftily1644782craftily
crispily1574692crispily
crustal939022crustal_
crustier10259532crustier
crusting113612792crusting
crusty114911342crust__y
cushily15257922c_ushily
dustily113211522_dustily
frostily1436692frostily
fruitily1445142fruitily
fustily133111372_fustily
gustily113010902_gustily
lustily103611242_lustily
mustily123613632_mustily
rusticly1345182_rusticly
ruttily10338612_ruttily
artily92814713ar__tily
brassily1336623brassily
bristly12178063brist_ly
brutely1235933bru_tely
brutify1543883bru_tify
bushily15268893_bushily
busily112211503_bus_ily
cattily123210853c_attily
causally1356613causally
caustic1139753causti_c
caustics1237483caustics
chastely1635813chastely
chastity1645273chastity
chattily1634603chattily
chubbily2042913chubbily
chummily2042843chummily
chunkily2043083chunkily
classily1336623classily
clumsily1544003clumsily
clustery13317113clustery
cosily113613853c_os_ily
costly114012333c_ost_ly
courtly1256923court_ly
cousinly1345933cousinly
crabbily1744343crabbily
craggily1543703craggily
crankily1755623crankily
crassly1276653cras_sly
crazily2136923cr_azily
creakily1735393creakily
creamily1536363creamily
creepily1574953creepily
crestal9312133crestal_
cresting114017043cresting
crisply14426523cris_ply
croakily1744733croakily
crossly1277273cros_sly
crostini1038293crostini
crostino1038883crostino
croupily1544743croupily
crousely1346563crous_ely
crucify1744063cru_cify
crudely1336273cru_dely
crudity1336043cru_dity
cruelly1236563cru_elly
crumbly16347523cru_mbly
crumply16336093cru_mply
crunchily1943193crunchily
crushing143010053crushing
crushingly1963603crushingly
crust75827663crust___
crusted103712753crust_ed
crustiest112410053crustiest
crustose1045503crustose
crusts84916543crust__s
crystal1237433crystal_
crystals1347173crystals
curlily1238383c_urlily
cursedly1444183cursedly
cursorily1442923cursorily
curtly1149283c_urt_ly
custody1334093c_ustody
cutely115312803c_u_tely
draftily1534413draftily
dressily1246443dressily
duskily15236743_duskily
faultily1474523faultily
feistily1445263feistily
friskily1834503friskily
fructify1942353fructify
frumpily1843323frumpily
frustule1154483frustule
fussily13267603_fussily
goutily1137933gou_tily
grassily1236433grassily
gristly11187333grist_ly
grittily1244183grittily
grubbily1642973grubbily
gruffily1863083gruffily
grumpily1643463grumpily
gushily14257823_gushily
gutsily11267223_gutsily
hastily133010663_hastily
huskily17236333_huskily
jauntily1834173jauntily
justify2034663_justify
justly16307253_just_ly
lousily1038333lous_ily
mistily122612343_mistily
mousily1239393mous_ily
mushily152410093_mushily
muskily16289043_muskily
mussily12279773_mussily
nastily103011033_nastily
nuttily10308633_nuttily
plushily1664423plushily
prettily1337283prettily
prissily1346693prissily
prosily12611633pros_ily
pursily1238213purs_ily
pushily15247983_pushily
riskily1436413_riskily
rosily93914713_ros_ily
ruddily1236303_ruddily
russify1334063_russify
rustic8712673_rusti_c
rustics9810733_rustics
rustier74416363_rustier
rusting83821263_rusting
rustle63615413_rust_le
rusty85221053_rust__y
rutile65217683_ru_tile
scrubbily1842313scrubbily
scruffily2041883scruffily
scrutiny1344773scru_tiny
slushily1445013slushily
smuttily1344273smuttily
tastily103311643_tastily
testily102910803_testily
trashily1437323trashily
trustier8268683trustier
trusties82712853trusties
trusting93411653trusting
trustingly1444373trustingly
trusty94710113trust__y
tuftily1335573_tuftily
yeastily1444573yeastily
zestily19167563_zestily

Search took 8 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.420425454.8
2DLD Change Limit1461621497.19020328.5
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.67323288.3
 
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.