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

88 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
pebblier145326(None) 
bubblier1184472bubblier
nubblier1254412nubblier
pearlier1037322pearlier
pebble1238002pebbl_e_
pebbled1445392pebbl_ed
pebbles1337572pebbl_es
pebbliest1543712pebbliest
pebbling1535072pebbling
pedalier1137602pedalier
rubblier1244912rubblier
wabblier15375492wabblier
webbier1445422webb_ier
wobblier15325202wobblier
babbler104012823babbl_er
belier84423563__belier
bubbler103611783bubbl_er
bubblies1166773bubblies
burblier1255603burblier
cobbier133410163cobb_ier
cobbler133311823cobbl_er
dabbler124012153dabbl_er
deadlier1036863deadlier
dibbler124510283dibbl_er
earlier72612743_earlier
eelier64216463_e_elier
featlier1136453featlier
feebler1235823feebl_er
gabbier12379633gabb_ier
gabbler124013303gabbl_er
gobbler123310023gobbl_er
herbier1239593herb_ier
hobbler143710403hobbl_er
kebbie1435813kebb_ie_
kebbies1537253kebb_ies
knobblier1741923knobblier
marblier1256343marblier
mealier93015903me_alier
measlier1036013measlier
nearlier836793nearlier
nebulizer2043263nebulizer
nettlier864813nettlier
nibbler11379273nibbl_er
nobbier11309163nobb_ier
nobbler113211183nobbl_er
nubbier11308133nubb_ier
palier85023563p__alier
pallier94417163p_allier
peachier1548623peachier
peakier134411443pe_akier
pearler9310373pearl_er
peatier94017233pe_atier
pebbly1545083pebbl__y
peckier153910523pe_ckier
peculiar1245453peculiar
pedaler103410693pedal_er
pedalfer1443273pedalfer
pedaliers1245183pedaliers
pedaller1136093pedaller
peddler113210493peddl_er
pedler93614613pe_dl_er
peeler83517383pe_el_er
pelter83321623pe__lter
penciler1237113penciler
peopler1138073peopl_er
peppier10268323pe_ppier
perkier133813123pe_rkier
peskier13319113pe_skier
pestier94317403pe_stier
pettier94213613pe_ttier
pimplier1445413pimplier
plier75221283p___lier
portlier1038373portlier
puddlier1234213puddlier
rabbler113514093rabbl_er
relier65826183re__lier
replier94214973re_plier
ribbier1137593ribb_ier
seemlier1035193seemlier
stubblier1343203stubblier
tremblier1343283tremblier
tubbier11237743tubb_ier
vealier102712173ve_alier
wabbler143511923wabbl_er
wamblier15275733wamblier
weaklier1534263weaklier
wobbler14329823wobbl_er
wobblies15297233wobblies

Search took 7 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.1701051123.5
2DLD Change Limit146162886.61022112.3
3Display Results88880.0302933.3
 (SQL Overall)178691886.81026239.5
 
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.