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

144 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
crumbiest153625(None) 
crumbliest1643891crumbliest
crummiest1545561crummiest
brumbies1436532brumbies_
chubbiest1843752chubbiest
chummiest1834642chummiest
clubbiest1534272clubbiest
clumpiest1535342clumpiest
clumsiest1335392clumsiest
crabbiest1535622crabbiest
crampiest15268612crampiest
crimpiest15237182crimpiest
cruddiest1334452cruddiest
crumbier1456362crumbie_r
crumbles14329682crumbles_
crummies1437642crummies_
crumpliest1644112crumpliest
crustiest112410042crustiest
drumliest1235422drumliest
frumpiest1634542frumpiest
grubbiest1434252grubbiest
grumpiest1435022grumpiest
rubiest92914422_ru_biest
rummiest12299352_rummiest
scrubbiest1643162scrubbiest
brambliest1643773brambliest
brushiest14297543brushiest
bumpiest1437873_bumpiest
cambist13312113c_ambi_st
campiest142212133c_ampiest
chromiest1637783chrom_iest
chuffiest2044393chuffiest
chunkiest1835263chunkiest
clammiest1535733clammiest
clunkiest1535163clunkiest
cobbiest14118523c_obbiest
comfiest1539133c_omfiest
couthiest1439403couthiest
craftiest1436913craftiest
craggiest13116523craggiest
crambes1339953cramb_es_
cramboes1436543cramboes_
crankiest1538823crankiest
crappiest15267263crappiest
crawliest14187403crawliest
craziest19319923cr_aziest
creakiest15238593creakiest
creamiest13248933creamiest
creasiest11229943creasiest
creepiest1337063creepiest
crepiest12310383cr_epiest
crispiest13197423crispiest
croakiest15167173croakiest
croupiest1337053croupiest
crudest104510333cru__dest
cruelest1059183cru_elest
cruellest1155583cruellest
crumbed14378473crumb_e_d
crumber13339643crumb_e_r
crumbers14338223crumb_ers
crumbing15267813crumbi_ng
crumble133410403crumble__
crumbled15357443crumble_d
crumblier1543873crumblie_r
crumbliness1742573crumbliness
crumbs12409233crumb__s_
crumbums1642733crumbums_
crummie1336153crummie__
crummier1435603crummie_r
crumminess1643683crumminess
crumpet133711063crum_pe_t
crumpets14335943crum_pets
crumples14348813crumples_
crunchiest1764793crunchiest
cubbies133312883c_ubbies_
cubist104214443c_u_bi_st
cumbias13338963c_umbias_
cuppiest1448193c_uppiest
curdiest112511393c_urdiest
curliest102713113c_urliest
curviest13309673c_urviest
cushiest133411043c_ushiest
daubiest1138233dau_biest
druggiest12134973druggiest
drumbeat1343973drumb_eat
drumbles13277723drumbles_
dumbest1238743_dumb_est
dumpiest1338743_dumpiest
fruitiest1237383fruitiest
fumiest12312193_fum_iest
glumpiest1434943glumpiest
grabbiest1435323grabbiest
grimiest11299823grim_iest
gruffiest1634523gruffiest
grumbles13288873grumbles_
grummest13286363grum_mest
grungiest1135803grungiest
gummiest13269023_gummiest
humblest15288283_humblest
humpiest1538963_humpiest
jumpiest1936863_jumpiest
knubbiest1752613knubbiest
lambiest122410183_lambiest
limbiest12258893_limbiest
lumpiest1239253_lumpiest
nubbiest12117303_nubbiest
numbest1138793_numb_est
orbiest9312413or__biest
plumiest122110293plum_iest
plummiest1544973plummiest
rammiest12299933_rammiest
ribbiest1237583_ribbiest
rimiest93215853_rim_iest
rubbies114114113_rubbies_
rubbliest1354683_rubbliest
rubies84420343_ru_bies_
ruddiest10278543_ruddiest
rugbies10339353_rugbies_
ruliest72816423_ru_liest
rumbles114018393_rumbles_
rummest11279833_rum_mest
rummies113212793_rummies_
rumpliest1345303_rumpliest
runniest82911203_runniest
runtiest83014513_runtiest
rushiest113312923_rushiest
rustiest83116803_rustiest
ruttiest82712663_ruttiest
scrimpiest1643743scrimpiest
scruffiest1842923scruffiest
scummiest1535203scummiest
shrubbiest1742353shrubbiest
slummiest1335653slummiest
snubbiest1345063snubbiest
spumiest1238193spum_iest
stubbiest1345473stubbiest
stumpiest1335843stumpiest
thrummiest1742093thrummiest
trampiest13227893trampiest
trembliest1443633trembliest
trustiest9239083trustiest
tubbiest12117293_tubbiest
wombiest1536893_wombiest
yummiest15256723_yummiest

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411448.03318503.8
3Display Results1441440.0602400.0
 (SQL Overall)1786911448.24921662.1
 
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.