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

101 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
onshore1031001(None) 
inshore1038721inshore
ashore9414612_ashore
longshore1343952longshore
offshore1742542offshore
oospore939012oospore
shore85432642__shore
unshorn1036942unshorn
unswore1039052unswore
alongshore1451913alongshore
anchor113911973anchor_
anchored1438593anchored
anchoret13412453anchoret
anchors123912953anchors
anymore1256243anymore
asshole1046793asshole
chore105126763__chore
console92715983cons_ole
consort91319903cons_ort
conspire1257873conspire
encore8314773en_core
ensnare767123ensnare
ensphere1366073ensphere
ensure63416003ens_ure
foreshore15118203foreshore
forswore14106953forswore
gonophore1546203gonophore
gonopore1146373gonopore
inhere9313713in_here
inkhorn1444363inkhorn
insnare748243insnare
insole63515863ins_ole
insphere1355963insphere
inspire938253inspire
insure63416603ins_ure
ionophore1446603ionophore
longhorn1245423longhorn
noncore9411953noncore
nonhome1248833nonhome
nonstory1148063nonstory
nosher94616363nosher_
noshers103614323noshers
nowhere1337203nowhere
obscure1145333obscure
ochone11311293o_chone
ochre103411593o_ch_re
offshores1842353offshores
oilhole1046263oilhole
omnivore1342703omnivore
onside7511803ons_ide
onstage838363onstage
oosphere1355983oosphere
oospores1049523oospores
osmole8128513o_smole
osmose8108003o_smose
outscore10169203outscore
outshone1149343outshone
outsnore8187683outsnore
outswore11168673outswore
outwore101912693outwore
pishoge1336693pishoge
poechore1547853poechore
rescore95616193rescore
reshoe92816483resho_e
reshone102414163reshone
restore75822973restore
score75526733__score
seashore1147713seashore
share86437083__share
shire84727133__shire
shoe75933433__sho_e
shoer84722153__shoer
shone83725973__shone
shored105723643__shored
shores94830403__shores
shorl84720243__shorl
shorn85722173__shorn
short85040523__short
shote85526083__shote
shove114421033__shove
snore55424953__snore
sore47059533__s_ore
spore75428593__spore
store56333813__store
swore84920813__swore
toeshoe1047843toesho_e
tonsure758783tons_ure
tussore7317283tussore
unchoke16248193unchoke
unhorse1038583un_horse
unshared121510703unshared
unsharp1235543unsharp
unshod1067603unsho_d
unshowy1644173unshowy
unsphere1355843unsphere
unspoke1336573unspoke
unsure62815413uns_ure
unsworn1046843unsworn
whore116018043__whore
zoochore2245783zoochore
zoospore1945633zoospore

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 Filter1786911340270.296603685.8
2DLD Change Limit1340271017.72017361.0
3Display Results1011010.0303366.7
 (SQL Overall)1786911018.04622208.7
 
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.