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

116 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
glairiest103548(None) 
glariest92012521gla_riest
airiest74221012__airiest
gladiest101710332gla_diest
gladliest1135372gladliest
glaires84010132glair_es_
glairier944832glairie_r
glassiest10279242glassiest
glaziest18227912gla_ziest
grainiest10188992grainiest
hairiest11612462_hairiest
aeriest73924053__aeriest
airest63825263__air_est
blastiest111710043blastiest
bleariest1158843bleariest
blurriest1155153blurriest
brainiest11209723brainiest
chariest13315503cha_riest
charriest1438253charriest
clammiest1535733clammiest
clankiest1536663clankiest
claries93422203cla_ries_
classiest11309543classiest
clayiest1337913cla_yiest
dairies84217733_dairies_
fairest10412293_fair_est
fairies103516043_fairies_
flabbiest1644203flabbiest
flaggiest14145503flaggiest
flakiest153210543fla_kiest
flamiest133111973fla_miest
flappiest1644853flappiest
flashiest1557983flashiest
flawiest14298573fla_wiest
flaxiest18298183fla_xiest
flirtiest1236193fl_irtiest
gabbiest1337273g_abbiest
gainliest1037133g_ainliest
gamiest102816233g_a_miest
gammiest13339333g_ammiest
gappiest13259473g_appiest
gassiest93212523g_assiest
gaudiest1039393g_audiest
gauziest1836233g_auziest
gawkiest16327313g_awkiest
gharries12318203gharries_
girliest93010403g__irliest
gladdest11145843gla_ddest
glaiket1238363glai_ke_t
glaikit1244633glaiki__t
glaire74411293glair_e__
glaired9387743glair_e_d
glairing1047283glairi_ng
glairs75211333glair__s_
glaives11347833glai_ves_
glares75518863gla_r_es_
glarier84112203gla_rie_r
glariness1038553glariness
glassies94012273glassies_
glazieries2043573glazieries_
gleamiest1235303gleamiest
gleetiest1035913gleetiest
glibbest1343683gl_ibbest
glintiest1037623glintiest
glitziest1944003glitziest
globbiest1444023globbiest
gloomiest1235603gloomiest
gloppiest1444823gloppiest
glories81915913gl_ories_
glossiest10277943glossiest
gluiest839773gl__uiest
glumpiest1434943glumpiest
gnarliest10186553gnarliest
gnattiest1035383gnattiest
goriest82218743g__oriest
grabbiest1435323grabbiest
grapiest112211923gra_piest
grassiest10309513grassiest
grimiest11299823g_rimiest
gripiest11289633g_ripiest
hoariest11312883hoa_riest
laciest93819033_la_ciest
laities7320343_laities_
lakiest113517263_la_kiest
lambiest122410183_lambiest
lankiest122912493_lankiest
lardiest93813883_lardiest
largest83715103_la_rgest
larkiest123713313_larkiest
lathiest11312653_lathiest
laziest163814473_la_ziest
leariest83117843_leariest
leeriest83112883_leeriest
limiest93716103_l_imiest
liniest73321153_l_iniest
miriest93619823__miriest
paltriest1138603paltriest
plainest10313613plai_nest
plashiest1478373plashiest
platiest103216083pla_tiest
prairies10411453prairies_
rainiest81214923_rainiest
scariest101615943sca_riest
scarriest11188393scarriest
slaggiest11157703slaggiest
slangiest10129073slangiest
slatiest82616263sla_tiest
slimiest10310743sl_imiest
sparriest11198783sparriest
spiriest102513453_spiriest
starriest9159763starriest
tarriest83215003_tarriest
teariest82417263tea_riest
wariest105122503_wa_riest
weariest112914793wea_riest
wiriest103816853__wiriest

Search took 10 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.453394461.4
2DLD Change Limit1486411169.18616181.3
3Display Results1161160.0462521.7
 (SQL Overall)1786911169.68518450.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.