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

104 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
walloping154559(None) 
galloping1356251galloping
wallopings1652711wallopings
wallowing1666071wallowing
allowing12369092_allowing
alloying12339142_alloying
balloting1238382balloting
dolloping1344992dolloping
fallowing1666432fallowing
galoping1258022ga_loping
halloaing1387032halloaing
halloing121510072hallo_ing
hallooing1366342hallooing
hallowing1676942hallowing
lolloping1244682lolloping
sallowing1357382sallowing
scalloping1543952scalloping
swallowing1743042swallowing
tallowing1366292tallowing
walling113520972wall__ing
willowing1645322willowing
allaying12339303_allaying
alleging1038473_alleging
allotting1046503_allotting
alluding1036953_alluding
alluring939073_alluring
allying113011663_all_ying
balling104424763ball__ing
ballooning1344723ballooning
ballpoint1345993ballpoint
bellowing1547193bellowing
billowing1545873billowing
blooping13248843_blooping
bolloxing1944773bolloxing
calling103826773call__ing
callousing1344273callousing
callusing1236173callusing
dallying13368493dall_ying
eloping103512833__eloping
escalloping1652153escalloping
falling113621583fall__ing
fellowing1655923fellowing
filliping1544233filliping
following1665753following
galleting1137623galleting
galling93921963gall__ing
gallying13328933gall_ying
haloing113814133ha_lo_ing
helloing12159123hello_ing
hilloaing1375433hilloaing
hilloing12158303hillo_ing
holloaing1385793holloaing
holloing12148823hollo_ing
hollooing1385363hollooing
hollowing1675933hollowing
hulloaing1384523hulloaing
hulloing12146703hullo_ing
hullooing1383993hullooing
lalling83519623lall__ing
looping103615283__looping
loping93921413___loping
malling103623663mall__ing
mellowing1545893mellowing
palleting1238733palleting
palling104024483pall__ing
palping124112873pa_l_ping
pillowing1545493pillowing
rallying12289013rall_ying
sallying12309853sall_ying
salvoing1236423salvo_ing
scallopini1452783scallopini
scolloping1543243scolloping
shallowing1744113shallowing
slaloming1244743slaloming
sloping104114073__sloping
tailoring1036403tailoring
tallaging1146483tallaging
tallying12318833tall_ying
waggoning1543593waggoning
wagoning1336923wa_goning
wailing113620903wail__ing
waling104525303wa_l__ing
walking154013303wa_l_king
wallop113310293wallop___
walloped14146833wallop_ed
walloper13147113wallop_er
wallopers14136273wallopers
wallops123410413wallop__s
waltzing2134263wa_ltzing
wantoning1337083wantoning
wapping153514603wa__pping
warping133715183wa__rping
wauling112713113waul__ing
wawling143810963wawl__ing
waygoing1633273waygo_ing
waylaying1953103waylaying
welcoming1743473welcoming
welling112920313well__ing
wellspring1642123wellspring
whelping17245333whel_ping
whooping17286633w_hooping
willing113821613will__ing
willying15306713will_ying
yellowing1655073yellowing

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411047.48619855.9
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.