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

118 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
mightier143638(None) 
eighties12710802eighties
fighter143010772fight_er
flightier1644422flightier
lighter113113442light_er
mightiest1546442mightiest
mightily1744622mightily
miltier93214962mi_ltier
mintier93615992mi_ntier
mistier93418712mi_stier
mitier83620672mi__tier
nightie1179652nightie_
nighties121011382nighties
righter113212382right_er
righties12711572righties
sighter113412112sight_er
sightlier1344452sightlier
tighter112910692tight_er
weightier1643312weightier
bighted142810923bight_ed
bighting15269453bighting
bittier94211663bi_ttier
blighter1466853blight_er
blighties1546223blighties
brighter1476663bright_er
dictier103411863di_ctier
dighted132511493dight_ed
dighting142510843dighting
digitizer2044393digitizer
dirtier83312093di_rtier
dishier113613403dish_ier
doughtier1443463doughtier
eighteen1245763eighteen
eightieth1643093eightieth
fighters15269403fight_ers
fighting162710083fighting
filthier1434073filthier
fishier13359853fish_ier
gigglier1154323gigglier
haughtier1642743haughtier
higher134610893high__er
highflier1942283highflier
highted152710163hight_ed
highting16259723highting
igniter8147673_igniter
jiggier16377823jig_gier
jigglier1754093jigglier
lighted122913503light_ed
lighten112811523light_en
lightener1345693lightener
lighters123111393light_ers
lighting132811833lighting
lightish1556623lightish
lintier73613803li_ntier
maltier93015483m_altier
matier84321523m__atier
meatier93214613m_eatier
meshier123410853mesh_ier
metier83517693m__etier
miffier1537023mi_ffier
might113827083might___
mightiness1645093mightiness
mights123516253might__s
mighty154310213might__y
milkier133411163mi_lkier
millier93716703mi_llier
milter84921233mi_lt_er
mincier113512473mi_ncier
mingier103815293mi_ngier
minster93914323minst_er
minter84425103mi_nt_er
minuter93510413minut_er
mirier83918363mi__rier
mirkier13319053mi_rkier
missteer1037223missteer
mister84728563mi_st_er
miter75734793mi__t_er
mither114218563mi__ther
mothier121910213moth_ier
mouthier13208173mouthier
muggier11288943mug_gier
mushier123813593mush_ier
mustier94017963m_ustier
mythier15125183myth_ier
naughtier1343103naughtier
niftier10328713ni_ftier
nigglier1044843nigglier
nigher103612753nigh__er
nightjar1943163nightjar
nightwear1642573nightwear
nittier73512243ni_ttier
piggier113510003pig_gier
pigsties1139783pigsties
pithier123010293pith_ier
pitier84019823pi__tier
plighter1476623plight_er
righted122912143right_ed
righters122610713right_ers
righting132610853righting
rightism14156963rightism
rightist12159143rightist
sigher103813703sigh__er
sighted123111523sight_ed
sighters122510603sight_ers
sighting133110863sighting
sightsee1245473sightsee
sightseer1343313sightseer
siltier73413863si_ltier
slighter1257823slight_er
tighten11288973tight_en
tightener1344703tightener
tightwire16102853tightwire
weighter1535603weight_er
wiftier13297733wi_ftier
wiggier12418863wig_gier
wigglier1354453wigglier
withier132910493with_ier
wittier103910823wi_ttier

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 Limit1461621186.94021060.8
3Display Results1181180.0601966.7
 (SQL Overall)1786911187.42024082.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.