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

94 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
octopus114481(None) 
octopi1036532octop_i
octopod1244892octopod
octopods1344342octopods
octopuses1343312octopuses
acetous9410363aceto_us
actors81016763acto_rs
autobus996513autobus
campus125213923_campus
carpus105514303_carpus
chops125019873_chop_s
chorus115014773_chorus
clonus85212413_clonus
clops95924853_clop_s
coccous1039003cocco_us
colobus11389373colobus
colonus94413443colonus
comous10816503como_us
conus76726533_c_onus
coops96229643_coop_s
coopts105814583_coopts
copes97747103_c_opes
cops86751373_c_op_s
corpus106015293_corpus
cotypes1437943cotypes
coups95522473_c_oups
coypous14248813coypous
coypus13389303_coypus
crocus104813173_crocus
crops96125233_crop_s
croups104312553_croups
doctors1039993docto_rs
ectopia1147693ectopia
ectopias1248273ectopias
ectopic1338153ectopic
ectypes1434803ectypes
estops84011223estop_s
icterus936073icterus
ictus7249703ict__us
metopes11311363metopes
netops839213netop_s
nocuous946583nocuo_us
obolus8378813o_bolus
occiput1344763occiput
occiputs1442483occiputs
ocellus935983ocellus
ochrous1237943ochrous
octads987333oct_ads
octanes91111393octanes
octans81411143oct_ans
octants9128733octants
octaves12316963octaves
octavos12134483octavos
octets839403oct_ets
octopodes1443913octopodes
octrois938333octrois
octuple1153993octuple
octuples1244133octuples
octuply1443133octuply
octyls11135323oct_yls
oculus8178393oc_ulus
odious749933odio_us
oops65232673o__op_s
opus66420593___opus
orlops847303orlop_s
ormolus934743ormolus
osmous8138183osmo_us
ostoses71213553ostoses
ostosis71310123ostosis
ottos54714323otto__s
outpour937423outpour
outpours1036683outpours
outpush1245493out_push
output8712853out_put
outputs988493out_puts
postops11311713postop_s
scoops105414363scoop_s
scopes104719593sc_opes
scops95820193sc_op_s
setous64917373seto_us
stopes84525893_stopes
stops74827283_stop_s
stoups85313273_stoups
tofus86415423__tofus
tolus55024483__tolus
tonus56324303__tonus
topes76941763__topes
tophs105220053__tophs
tophus115210363__tophus
topis76025833__topis
topos75726393__topos
tops66248123__top_s
torus54329763__torus
xenopus1642983xenopus

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 Filter1786911340270.406440125.6
2DLD Change Limit134027945.76623244.4
3Display Results94940.0332848.5
 (SQL Overall)178691946.20528797.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.