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 “governed” 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
governed133519(None) 
caverned1436162caverned
covered133315292cover_ed
dovened12389062dove_ned
govern1036822govern__
governess1346172governess
governor1243282governor
governs1136102govern_s
hovered143411572hover_ed
overbed132811852_overbed
overed102216622_over_ed
overfed142510252_overfed
overnew13268132_overnew
adverted1336103adverted
averred11237593_averred
averted112211613_averted
bowered133113043bower_ed
clovered14187363clover_ed
coerced1238583co_erced
cohered133514693coher_ed
concerned1438643concerned
convened143412223conve_ned
converged1636973converged
conversed1538683conversed
converted15311563converted
corned95224523co__rned
covaried1448003covaried
coverer123113523cover_er
coverlet13413013coverlet
coverlid1445943coverlid
coveted133011523cove_ted
cowered133214653cower_ed
cozened19349183coze_ned
davened124610073dave_ned
decerned1237263decerned
deveined1336673deveined
diverged14256883diverged
diverted13199583diverted
dowered122811553dower_ed
dozened18377453doze_ned
evened101010313_eve_ned
everted112711853_everted
fevered14339723fever_ed
foveated1536293foveated
gaveled12399133gave_led
gavelled13387363gavelled
girned84010513g__irned
gleaned9349423g_leaned
glowered1345753glower_ed
goffered1634523goffer_ed
gomerel1036393gomer_el
gored75227083go__r_ed
gorged95016983go__rged
gormed105013833go__rmed
governessy1741853governessy
governing1435533governing
government1645643government
governors1343883governors
gowaned1235763go_waned
gowned114410133go__wned
greened93111263g_reened
groveled13345453grove_led
grovelled1454183grovelled
havened14429243have_ned
havered144011453haver_ed
homered133212713homer_ed
hoovered15195413hoover_ed
horned105718703ho__rned
hoveled14209293hove_led
hovelled15146843hovelled
hoverer13319823hover_er
interned93016653interned
inversed12269283inversed
inverted122312163inverted
kerned114112933__kerned
levered114212303lever_ed
livened11238933live_ned
livered113111633liver_ed
liveried1238733liveried
louvered1244993louver_ed
lowered112711913lower_ed
misgoverned1851813misgoverned
moderne1037123moderne_
moderner1145523moderner
modernes1138423modernes
mourned1037763mo_urned
obverted1435103obverted
omened93711003_ome_ned
opened94311863_ope_ned
overaged13511673_overaged
overawed1579973_overawed
overbet122716063_overbet
overbid132710273_overbid
overbred1459853_overbred
overdid12199173_overdid
overdyed16126513_overdyed
overfeed15299443_overfeed
overhead152110363_overhead
overheld15197373_overheld
overlend122510103_overlend
overlet102619033_overlet
overlewd15216273_overlewd
overmen12311803_overmen
overmined1539603_overmined
overnear11238473_overnear
overneat112713643_overneat
oversad11259963_oversad
oversea102412113_oversea
oversee102717603_oversee
overseed122513353_overseed
overset102821473_overset
oversew132810833_oversew
overused1249443_overused
overwet132013933_overwet
powered132911643power_ed
proverbed1743813proverbed
ravened115012283rave_ned
reverbed14269223reverbed
revered112819333rever_ed
reverend12288853reverend
reversed122711613reversed
reverted122714713reverted
riverbed14245143riverbed
rogered939553roger_ed
secerned1136103secerned
severed113513863sever_ed
sobered102912433sober_ed
sorned74820043so__rned
taverner1134423taverner
tokened1236393toke_ned
towered112911403tower_ed
unveined1258003unveined
unversed122310433unversed
veined104413913__veined
verged114815163__verged
versed104515513__versed
wavered142910433waver_ed

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 Filter1786911461620.530337152.8
2DLD Change Limit1461621377.40619735.6
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.99922339.2
 
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.