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 “octanet” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
octane81411631octane_
octanes91111391octanes
octant81216551octan_t
octan71313482octan__
octanol944742octanol
octans81411142octan_s
octants9128732octants
octave11157342octave_
octaves12316962octaves
octet7324062oct__et
alkanet113714433alkanet
butane8313653butane_
butanes9312743butanes
cadet85339343_c_adet
cane66653123_c_ane_
caned85838093_c_aned
caner75334773_c_aner
canes75350373_c_anes
canst74932213_c_anst
cant66362033_c_an_t
caret75360563_c_aret
carnet84732873_carnet
castanet10416193castanet
cetane8315283cetane_
cetanes9315133cetanes
chalet113825993_chalet
chant105932693_chan_t
claret84026573_claret
cocoanut1246903cocoanut
cornet84436733_cornet
coronet94227173coronet
cotan71521783cotan__
cotangent1246833cotangent
cotans81317923cotan_s
crane75331603_crane_
craned96121653_craned
cranes84330753_cranes
cygnet1237893_cygnet
ectases92911673ectases
extant132714753extan_t
extranet15412993extranet
fontanel1145553fontanel
intranet8418443intranet
montane91313623montane_
montanes101114523montanes
mutant8317693mutan_t
natant6318733natan_t
nutant6316383nutan_t
obtained1136533obtained
obtainer1045793obtainer
ocean71212963ocean__
oceanaut1043763oceanaut
oceanic1146163oceanic
oceans81211003ocean_s
ochone11311293ochone_
octad81510653octa__d
octadic1245713octadic
octads987333octa_ds
octagon1045243octagon
octal71214723octa__l
octameter1355013octameter
octangle1143833octangle
octangles1243463octangles
octanols1044553octanols
octantal1044563octantal
octaval1243583octaval
octavo11124783octa_vo
octavos12134483octavos
octets839403oct__ets
octette946423octette
octuplet1244843octuplet
oftener1035923oftener
oftenest1148863oftenest
oscitant1046903oscitan_t
outact8317203outa_ct
outage72017533outage_
outages82317323outages
outate62923403outate_
outlet63728683out_let
outset64027453out_set
outwent10311363outwent
planet84228353_planet
satinet7325283satinet
scant79735073sc_an_t
soutane7312063soutane_
soutanes8312933soutanes
stane55933003_stane_
staned74824643_staned
stanes64933403_stanes
tacet75840023__tacet
tenet55542213__tenet

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 Filter1786911340270.420425454.8
2DLD Change Limit134027916.89019452.4
3Display Results91910.0332757.6
 (SQL Overall)178691917.34324334.9
 
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.