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 “outglittering” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
outglittering155103(None) 
antilittering1462153antilittering
glittering1296003___glittering
outglitter1181993outglitter___
outglittered145763outglitter_ed
outglitters1271393outglitter__s
flittering1486504___flittering
glistering12106424___glistering
littering102411984____littering
outdelivering186894outdeli_vering
outfitting1465824out_fitt__ing
outglaring1246274outgl___aring
outhitting1446334out_hitt__ing
outmastering1552954out_mastering
outplotting1443754outplott__ing
outsitting1147134out_sitt__ing
outsteering1244554out__steering
outwitting1445554out_witt__ing
tittering102310314__t__ittering
twittering1444584__t_wittering
uncluttering1551804_uncluttering
unflattering1672044_unflattering
betattering1444145bet__attering
bittering122511995____bittering
blattering13108715___blattering
blistering13107065___blistering
blithering16116125___blithering
buttering122312525bu____ttering
chittering16107185___chittering
clattering13109235___clattering
cluttering13106835___cluttering
embittering1642945__embittering
flattering1498745___flattering
fluttering14106295___fluttering
frittering14105625___frittering
gettering112310035___g_ettering
glimmering1643715___glimmering
glistening1294285___glistening
glitteringly1751865___glitteringly
guttering112410445___g_uttering
imbittering1642355__imbittering
jittering17218425____jittering
lettering102112075____lettering
mouthwatering2261345mout_hwatering
mutineering1453235mut__ineering
muttering122611325mu____ttering
outbitching1992865out_bi_tching
outbleating1444885outbleat__ing
outcapering1643335out__capering
outclimbing1872245outcli__mbing
outfiguring1682245out_fi_guring
outfiring1338165out_fi___ring
outfitter1243915out_fitter___
outfitters1342755out_fitter__s
outfloating1544365outfloat__ing
outgaining1237095outgai___ning
outgiving1436215outg_i___ving
outgleaming1542535outgl__eaming
outglowing1544685outgl___owing
outgrinning1353695outgri__nning
outguiding1344735outgui___ding
outhomering1743905out__homering
outjutting1844265out_jutt__ing
outlasting1137525out_last__ing
outlining10310505out_li___ning
outliving1337795out_li___ving
outnumbering1751165out_numbering
outpainting1445155outpaint__ing
outpitching1962975out_pi_tching
outpitying1644775out_pi_t_ying
outpointing1445105outpoint__ing
outpoliticking236635outpoliticking
outpowering1743175out__powering
outputting1345085out_putt__ing
outsleeping1443295outsl__eeping
outslicking1843735outsli__cking
outstaring1137805out___staring
outthieving1842455outthi__eving
outtowering1542855out__towering
outtrotting1244105outtrott__ing
outwaiting1446735outwai_t__ing
outwriting1447185outwri_t__ing
outwritten1342715outwritte__n_
overwintering2053055overwintering
puttering122611645pu____ttering
registering1346395_reg_istering
relettering1255515__relettering
skittering1535395___skittering
slithering1496895___slithering
splattering1454545__splattering
splintering1444295__splintering
spluttering1463365__spluttering
stuttering1196355_st__uttering
subclustering1861115subclustering
tattering102212325__t__attering
tottering10229615__t__ottering
unfettering1543705_u_nfettering
unlimbering1652485_u_nlimbering
unmitering1345005_u_nmi_tering
upgathering1842205_upg_athering
uttering91613085_u____ttering

Search took 9 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901018.45314762.8
3Display Results1011010.0631603.2
 (SQL Overall)1786911018.90620064.1
 
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.