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

137 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
overloads1312766(None) 
overgoads14115891overgoads
overload12119281overload_
overlords13117211overlords
overclouds1643492overclouds
overcoats1438852overcoats
overfloods1743432overfloods
overgoad13127152overgoad_
overheads16248932overheads
overholds16206322overholds
overlade12611552overl_ade
overlades13510352overl_ades
overlands13218882overlands
overlaps13219522overl_aps
overlays14239692overl_ays
overleaps14226782overleaps
overlends13237522overlends
overloaded1566592overloaded
overlooks1685482overlooks
overlord12119172overlord_
overloud12117752overloud_
overloves15218672overloves
oversoaks1635982oversoaks
overwords16127632overwords
carloads1138393_carloads
coverlids1544743coverl_ids
freeloads1343903freeloads
offloads1542723o_ffloads
onloads8246673o__nloads
overbears14208483overbears
overbeats14279813overbeats
overbids14248903over_bids
overblows1745003overblo_ws
overboard1537813overboard
overboils1436623overboils
overbold14208533overbold_
overbooks1855873overbooks
overbroad1545433overbroad_
overclass1436963overclass
overcleans15134883overcleans
overclears15134323overclears
overcloud1544743overcloud_
overcoach1944793overcoach
overcoat13312103overcoa_t
overcold14208483overcold_
overcomes161110333overcomes
overcooks1875763overcooks
overcools1476773overcools
overcrams1646413overcrams
overcrowds1943093overcrowds
overdoers13117393overdoers
overdoes121212543overdo_es
overdogs13127493overdo_gs
overdoses13119793overdoses
overdraws1645663overdraws
overeats112415253over_eats
overfears15236943overfears
overfeeds16226023overfeeds
overflood1644523overflood_
overflows1845113overflo_ws
overfocus1744263overfocus
overfond1537323overfond_
overfunds1644593overfunds
overgilds1445183overgilds
overgirds1445163overgirds
overglad13116533overglad_
overgoaded1655573overgoaded
overgrade1457623overgrade
overgrades1556923overgrades
overhands16227803overhands
overhead152110363overhead_
overheaps17226953overheaps
overhears15258873overhears
overheats15229983overheats
overhold15219003overhold_
overhopes1738143overhopes
overjoys2135183overjo_ys
overladed1459223overl_aded
overladen1367643overl_aden
overlaid122410383overl_aid
overlain112112443overl_ain
overland122312003overl_and
overlap12239833overl_a_p
overlate11716283overl_ate
overlax17238413overl_a_x
overlay132410833overl_a_y
overleaf14237973overlea_f
overleap13237833overlea_p
overleapt14247883overleapt
overlearn1235903overlearn
overlearns1344993overlearns
overlend122510103overlend_
overlets112312363overl_ets
overlewd15216263overlewd_
overlies112417043overl_ies
overlives152210143overlives
overloading1647333overloading
overlong1238123overlo_ng
overlook1596423overlo_ok
overlorded1555853overlorded
overlove14239173overlo_ve
overloved16217643overloved
overmans13310313over_mans
overpass13258653over_pass
overpays16248253over_pays
overplaids1645433overplaids
overplans14249573overplans
overplays17287013overplays
overplots1436953overplo_ts
overroast1247873overroast
overroasts1344933overroasts
overrode121810573overro_de
oversad11259963over_sad_
overseas112612423oversea_s
overseeds13248893overseeds
overshade1636993overshade
overshades1746283overshades
oversoak1536993oversoa_k
oversold12218923oversold_
oversouls1236603oversouls
overstays1535943overstays
oversuds1237033over_suds
overtoils1237083overtoils
overtones121011853overtones
overtops1338513overto_ps
overtrade1348503overtrade
overtrades1457483overtrades
overvotes1538423overvotes
overwears15227873overwears
overwinds1645573overwinds
overword15119223overword_
overworks19127383overworks
overzeals2165763overzeals
preloads1157513pre_loads
reloads8911313_re_loads
underloads1245233underloads
vanloads1264163_vanloads

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411377.98618612.7
3Display Results1371370.0602283.3
 (SQL Overall)1786911378.20221786.3
 
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.