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

97 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
crumblier154387(None) 
crumbier1456361crumb_ier
crumplier1543781crumplier
bramblier1543502bramblier
crumber13339642crumb__er
crumble133410402crumbl_e_
crumbled15357442crumbl_ed
crumbles14329682crumbl_es
crumbliest1643902crumbliest
crumbling1655082crumbling
crummier1435602crum_mier
drumlier1134522drum_lier
grumbler13866682grumbl_er
rubblier1244912_rubblier
rumbler113514112_rumbl_er
rumplier1235302_rumplier
tremblier1343282tremblier
brumbies1436533brumb_ies
bubblier1184473_bubblier
bumbler134013233_bumbl_er
burblier1255603_burblier
chimblies1845033chimblies
chubbier1733893chu_bbier
chummier1734513chum_mier
clubbier1434833clu_bbier
clumber134011443clumb__er
clumpier1435583clum_pier
clumsier1234733clum_sier
comelier12310653c_omelier
complier14310253c_omplier
courtlier1154463courtlier
crabbier14326803cr_abbier
cracklier1744823cracklier
crampier14288903cram_pier
crawlier13216873cr_awlier
crimpier14287323crim_pier
crinklier1543843crinklier
crucifier1644313crucifier
cruddier1244153cru_ddier
crueler939023cru_el_er
crueller1056453cru_eller
cruller968753cru__ller
crumbed14378473crumb__ed
crumbers14338243crumb__ers
crumbiest1536253crumb_iest
crumbing15267813crumb_ing
crumbliness1742573crumbliness
crumblings1742513crumblings
crumbly16347523crumbl__y
crummie1336153crum_mie_
crummies1437643crum_mies
crumple13368363crumpl_e_
crumpled15296873crumpl_ed
crumples14348813crumpl_es
crumpliest1644123crumpliest
crumpling1645323crumpling
crunchier1644683crunchier
crustier10259533cru_stier
cuddlier1234013c_uddlier
cumber124016703c_umb__er
cumberer14266993c_umberer
curlier93314183c_u_rlier
drumble12337893drumbl_e_
drumbled14266033drumbl_ed
drumbles13277723drumbl_es
drumbling1544033drumbling
frumpier1534173frum_pier
fumbler143610813_fumbl_er
grubbier13344753gru_bbier
grumble12349233grumbl_e_
grumbled14256753grumbl_ed
grumblers14245023grumbl_ers
grumbles13288873grumbl_es
grumbling1544083grumbling
grumpier1334803grum_pier
humbler143411943_humbl_er
jumbler183910273_jumbl_er
mumbler133510913_mumbl_er
nubblier1254413_nubblier
rambler113313263_rambl_er
rubier84814743_ru_b_ier
rufflier1434013_rufflier
rulier65016353_ru__lier
rumble103718813_rumbl_e_
rumbled124514593_rumbl_ed
rumblers123610743_rumbl_ers
rumbles114018393_rumbl_es
rumbling131910103_rumbling
rummier11309563_rum_mier
scrabblier1642773scrabblier
scrambler15165043scrambl_er
scrubbier1543333scru_bbier
stubblier1343203stubblier
stumbler1235813stumbl_er
trembler1235363trembl_er
tumbler113412823_tumbl_er
wamblier15275733_wamblier

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 Filter1786911486410.436409841.7
2DLD Change Limit148641976.67322275.0
3Display Results97970.0462108.7
 (SQL Overall)178691977.15524974.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.