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

135 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
chubbier173389(None) 
clubbier1434831clubbier
chubbiest1843752chubbiest
chubbily2042912chubbily
chuffier1934542chuffier
chummier1734512chummier
chunkier17395882chunkier
clubber13319592clubb_er
cobbier133410162c_obbier
crabbier14326802crabbier
crumbier1456362crumbier
cubbies133312882c_ubbies
grubbier13344752grubbier
hubbies143211562_hubbies
knubbier1642512knubbier
nubbier11308132_nubbier
scrubbier1543332scrubbier
shabbier1535182shabbier
shrubbier1642192shrubbier
snubbier1244992snubbier
stubbier1235352stubbier
tubbier11237742_tubbier
blubber10399293blubb_er
bubbies103913513_bubbies
bubbler103611783_bubbler
bubblier1184473_bubblier
cabbie122913353c_abbie_
cabbies133115163c_abbies
catbrier1236173catbrier
chaffier1935473chaffier
chalkier1736753chalkier
chamber164011063chamb_er
chancier1538823chancier
charier124317903ch_arier
charrier1378683charrier
chattier1337513chattier
cheekier1735103cheekier
cheerier1348003cheerier
cheesier1335963cheesier
chertier1387873chertier
chestier1387423chestier
chewier1537583ch_ewier
chichier1836023chichier
chillier13328423chillier
chinkier17377363chinkier
chippier17297673chippier
chirpier15276303chirpier
chokier1638043ch_okier
choosier1337173choosier
choppier17286643choppier
chromier1538033chromier
chubbiness1942553chubbiness
chubby1844123chubb__y
chuckies1937703chuckies
chuckler1935553chuckler
chudder14245943chu_dder
chuffer18337143chu_ffer
chugger1445373chu_gger
chukker1543833chu_kker
chunter123911483chu_nter
churchier1944153churchier
churner12298343chu_rner
clabber134210113clabb_er
clobber13378163clobb_er
clubbed14307453clubb_ed
clubbers14378583clubb_ers
clubbiest1534273clubbiest
clubbing15266513clubbing
clubbish1743813clubbish
clumber134011443clumb_er
clumpier1435583clumpier
clumsier1234733clumsier
clunkier14345793clunkier
cobber124116843c_obb_er
cobbler133311823c_obbler
courier93617893cou_rier
courtier1059333courtier
couthier13218913couthier
crabber133810733crabb_er
cribber13367663cribb_er
cruddier1244153cruddier
crumber13339643crumb_er
crumblier1543873crumblier
crummier1435603crummier
crustier10259533crustier
cubbish1635803c_ubbish
cuber95222533c_u_b_er
cumber124016703c_umb_er
cuppier1368323c_uppier
curber104517053c_urb_er
curdier103312623c_urdier
curlier93314183c_urlier
currier93316703c_urrier
curvier123110663c_urvier
cushier123610833c_ushier
daubier1037093dau_bier
drubber12357863drubb_er
dubber113814553_dubb_er
flabbier1534093flabbier
flubber14287713flubb_er
fubsier12367763_fubsier
gabbier12379633_gabbier
globbier1334243globbier
grabbier13316653grabbier
grubber12417913grubb_er
herbier1239593_herbier
hobber134114633_hobb_er
hobbies143813343_hobbies
hobbler143710403_hobbler
huffier1637493_huffier
hulkier14328973_hulkier
humbler143411943_humbler
humpier143110723_humpier
hunkier144512143_hunkier
hurrier103412943_hurrier
huskier14369763_huskier
knobbier1652703knobbier
lubber104214623_lubb_er
nobbier11309163_nobbier
nubblier1254413_nubblier
ribbier1137593_ribbier
rubber104715793_rubb_er
rubbies114114113_rubbies
rubblier1244913_rubblier
rubier84814743_ru_bier
scabbier1435133scabbier
scrubber1434113scrubb_er
slobbier1254633slobbier
slubber113010763slubb_er
snobbier1234633snobbier
snubber11277733snubb_er
squabbier2242753squabbier
stubblier1343203stubblier
tubber104313203_tubb_er
webbier1445423_webbier

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.1561145455.1
2DLD Change Limit1461621357.36019859.0
3Display Results1351350.0602250.0
 (SQL Overall)1786911357.57623586.5
 
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.