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

110 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
governing143553(None) 
caverning1536282caverning
covering142215722cover_ing
dovening13238352dove_ning
hovering151911142hover_ing
overing111918052_over_ing
adverting1437223adverting
averring12239063_averring
averting122512733_averting
bowering142911713bower_ing
coercing1349003co_ercing
cohering142413833coher_ing
concerning1548903concerning
convening15311193conve_ning
converging1758093converging
conversing16310543conversing
converting16313133converting
corning103720123co__rning
covarying1844133covarying
coverings15217893cover_ings
coversine1459703coversine
coveting141912303cove_ting
cowering142514033cower_ing
cozening20188303coze_ning
davening13258873dave_ning
decerning1337293decerning
deveining1436393deveining
diverging15226693diverging
diverting142410333diverting
dowering132510613dower_ing
dozening19236183doze_ning
evening11310223_eve_ning
everting122213133_everting
fevering152510083fever_ing
gaveling133410163gave_ling
gavelling14286873gavelling
girning93210693g__irning
gleaning10269323g_leaning
glowering1435653glower_ing
goffering1744483goffer_ing
gorging102611363go__rging
goring84119573go__r_ing
gorming112810833go__rming
govern1036823gover__n_
governance1654043governance
governed1335193govern_ed
governess1346173governess
government1645643government
governor1243283govern_or
governors1343883governors
governs1136103gover__ns
gowning12258833go__wning
greening103112533g_reening
groveling1435573grove_ling
grovelling1554163grovelling
havening15258553have_ning
havering152211053haver_ing
homering141512073homer_ing
hoovering1635753hoover_ing
horning113015003ho__rning
hoveling15189593hove_ling
hovelling1636163hovelling
interning10315253interning
inversing1389623inversing
inverting131013223inverting
kerning124010893__kerning
levering122212503lever_ing
livening12248153live_ning
livering122012383liver_ing
lowering122210913lower_ing
misgoverning1972043misgoverning
morning103215043mo__rning
mourning1156793mo_urning
nonearning1145183nonearning
obverting1536303obverting
omening10310093_ome_ning
opening1039923_ope_ning
overawing16710293_overawing
overbig13237543_overbi_g
overdoing1439143_overdoing
overhang15248863_overhang
overhung15235623_overhung
overkind1637953_overkind
overlong1238123_overlong
overlying1638003_overlying
overmine13313663_overmine
overmining1649113_overmining
overnice13310093_overnice
overswing1638453_overswing
overusing1339043_overusing
overwind1538533_overwind
powering142210803power_ing
proverbing1843783proverbing
ravening122611293rave_ning
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
reverting132315133reverting
rogering10310273roger_ing
secerning1246203secerning
severing122013853sever_ing
sobering111912783sober_ing
sorning83116813so__rning
sovereign1342253sovereign
tokening1336463toke_ning
towering122610873tower_ing
veining114713893__veining
verging123812303__verging
versing112314193__versing
wavering152410543waver_ing

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.406440125.6
2DLD Change Limit1486411106.25023782.6
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.70226662.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.