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

117 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
wallowing166607(None) 
allowing12369091_allowing
fallowing1666431fallowing
hallowing1676941hallowing
sallowing1357381sallowing
swallowing1743041swallowing
tallowing1366291tallowing
walloping1545591walloping
willowing1645321willowing
alloying12339142_alloying
balloting1238382balloting
bellowing1547192bellowing
billowing1545872billowing
fellowing1655922fellowing
following1665752following
galloping1356252galloping
halloaing1387032halloaing
halloing121510072hallo_ing
hallooing1366342hallooing
hollowing1675932hollowing
mellowing1545892mellowing
pillowing1545492pillowing
shallowing1744112shallowing
walling113520972wall__ing
wallopings1652712wallopings
yellowing1655072yellowing
allaying12339303_allaying
alleging1038473_alleging
allotting1046503_allotting
alluding1036953_alluding
alluring939073_alluring
allying113011663_all_ying
arrowing1237943_arrowing
avowing1466603_a_vowing
balling104424763ball__ing
ballooning1344723ballooning
blowing133813053__blowing
bolloxing1944773bolloxing
calling103826773call__ing
callousing1344273callousing
callusing1236173callusing
dallying13368493dall_ying
disallowing1643283disallowing
dolloping1344993dolloping
elbowing1435013_elbowing
falling113621583fall__ing
farrowing1645873farrowing
flowing143411763__flowing
followings1752823followings
galleting1137623galleting
galling93921963gall__ing
gallying13328933gall_ying
galoping1258023ga_loping
glowing123211793__glowing
gullwing13304923gull_wing
haloing113814133ha_lo_ing
harrowing1646433harrowing
helloing12159123hello_ing
hilloaing1375433hilloaing
hilloing12158303hillo_ing
holloaing1385793holloaing
holloing12148823hollo_ing
hollooing1385363hollooing
hulloaing1384523hulloaing
hulloing12146703hullo_ing
hullooing1383993hullooing
lalling83519623lall__ing
lolloping1244683lolloping
lowing104623273___lowing
malling103623663mall__ing
marrowing1546663marrowing
narrowing1345603narrowing
palleting1238733palleting
palling104024483pall__ing
plowing133111723__plowing
rallying12289013rall_ying
reflowing1636523reflowing
reglowing1436173reglowing
replowing1537413replowing
reswallowing1951363reswallowing
sallowish1544943sallowish
sallying12309853sall_ying
salvoing1236423salvo_ing
scalloping1543953scalloping
slaloming1244743slaloming
slowing112814743__slowing
tailoring1036403tailoring
tallaging1146483tallaging
tallying12318833tall_ying
unhallowing1851423unhallowing
upflowing1842933upflowing
waggoning1543593waggoning
wagoning1336923wa_goning
wailing113620903wail__ing
waling104525303wa_l__ing
walking154013303wa_l_king
wallow123913513wallow___
wallowed15148163wallow_ed
wallower14158933wallow_er
wallowers15127653wallowers
wallows133613533wallow__s
waltzing2134263wa_ltzing
wantoning1337083wantoning
wauling112713113waul__ing
wawling143810963wawl__ing
waxwing2154723wa__xwing
waygoing1633273waygo_ing
waylaying1953103waylaying
welcoming1743473welcoming
welling112920313well__ing
widowing1635183w_idowing
willing113821613will__ing
willowier1563783willowier
willying15306713will_ying
windowing1744813windowing
winnowing1643363winnowing
wowing133915393w___owing

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411176.43623095.2
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.91825829.9
 
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.