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

233 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
octants912873(None) 
octanes91111391octanes
octans81411141octan_s
octant81216551octant_
cants77036942_c_ants
chants115020392_chants
cotans81317922cotan_s
mutants938582mutants
oceans81211002ocean_s
octads987332octa_ds
octan71313482octan__
octane81411632octan_e
octanol944742octanol
octanols1044552octanols
octantal1044562octantal
octaves12316962octaves
octavos12134482octavos
octets839402oct_ets
outacts9310212outacts
scants85219722sc_ants
accents113511233accents
actings104512463actings
actins86321103actin_s
alants67722023_alants
ants47243473___ants
attaints846493attaints
bezants1877343bezants
brants85723053_brants
butanes9312743butanes
byzants2153223byzants
canes75350373_c_anes
cans65050843_c_an_s
canst74932213_c_anst
cant66362023_c_ant_
canto74931013_c_anto
cantos84826973_c_antos
cantus85117763_c_antus
canty105226803_c_anty
carts78946293_c_arts
casts77237793_c_asts
cats66356343_c_a_ts
cents74730333_c_ents
cetanes9315133cetanes
changs125215373_changs
chant105932693_chant_
chanty145215823_chanty
charts115823093_charts
chats105730093_cha_ts
chaunts1267083_chaunts
chints115117833_chints
clangs95113613_clangs
clanks124615183_clanks
clans75031013_clan_s
clasts84817293_clasts
coacts105314333_coacts
coapts104614013_coapts
coasts85719143_coasts
coats75635003_coa_ts
cobalts1139203cobalts
cocoanuts1343193cocoanuts
constants11410913constants
contacts123215213contacts
contents104018213contents
coolants1039943coolants
coranto9311893coranto
corantos10310103corantos
cotan71521783cotan__
cotenants1147283cotenants
counts84618273_counts
courants10310803courants
crafts115312743_crafts
cranes84330753_cranes
cranks125015313_cranks
cunts76125123_c_unts
cyans105714813_cyan_s
decants103514443decants
detents83615153detents
docents102810803doc_ents
dopants1038433dopants
eclats8313033ecla_ts
ectases92911673ectases
ectasis9249613ectasis
eluants737583eluants
enchants1347823enchants
entrants8311753entrants
errants7410633errants
etchants1346023etchants
excitants1864393excitants
extant132714753extant_
extents142610173extents
fondants1246203fondants
formants13269953formants
gelants82611443gelants
giants74713503_giants
gitanos837173gitanos
grants73722473_grants
hants86335403__hants
incants92012803incants
incitants1196193incitants
infants102210773infants
instants8910153instants
intents72115703intents
intrants8312863intrants
jurants14379213jurants
latents75214313latents
levants1037723levants
lochans1248833lochan_s
montanes101114523montanes
mordants1137143mordants
mutant8317693mutant_
natant6318733natant_
nutant6316383nutant_
oasts56529183o__asts
oats46554213o__a_ts
oblasts947293oblasts
obtains939163obtains
obtests9136233obtests
obtunds1033763obtunds
ocas66729633oc_a__s
occults1135123occults
occupants1543053occupants
ocean71212963ocean__
oceanauts1141773oceanauts
oceanic1146163oceanic
ocelots977233ocelots
ocicats11137413ocicats
octad81510653octa__d
octadic1245713octadic
octagon1045243octagon
octagons1144493octagons
octal71214723octa__l
octangle1143833octangle
octangles1243463octangles
octaval1243583octaval
octave11157343octa_ve
octavo11124783octa_vo
octet7324063oct_et_
octette946423octette
octettes1045533octettes
octopus1144813octopus
octrois938333octrois
octyls11135323oct_yls
odorants946043odorants
operants1039483operants
orangs74116033o_rangs
organs7912913organ_s
orients7311583orients
oscitant1046903oscitant_
ottars64112223otta_rs
ottavas1093483ottavas
ourangs8318503ourangs
outact8317203outact_
outadds936203outadds
outages82317323outages
outasks1138173outasks
outate62923403outa_te
outcasts10108683outcasts
outeats72215703outeats
outfasts11117233outfasts
outfits102210833outfits
outhits102213503outhits
outhunts1136033outhunts
outings84014753outings
outjuts1476483outjuts
outlands988563outlands
outlasts8108713outlasts
outlets73616363outlets
outmans92413283outman_s
outpaints1145283outpaints
outputs988493outputs
outranks12298823outranks
outsets73514923outsets
outsits73215253outsits
outvaunts1242743outvaunts
outwaits1137493outwaits
outwits103110863outwits
oxcarts1634313oxcarts
oxidants1643933oxidants
oxtails1436383oxtails
pants76536923__pants
patents94815203patents
pedants10310113pedants
plants84921803_plants
portents103512823portents
quants153614143_quants
rants55935343__rants
ratans63819373ratan_s
reactants1146623reactants
recants93217093recants
retints74717013retints
satangs8479713satangs
savants1038653savants
scans74625103sc_an_s
scant79735073sc_ant_
scanty114014663sc_anty
scarts85321493sc_arts
scats75930603sc_a_ts
scatts85914663sc_atts
scents85317023sc_ents
secants93413893secants
sextants15287383sextants
slants64819083_slants
sonants7511233sonants
soutanes8312933soutanes
stands75118053_stands
stanes64933403_stanes
stangs75018163_stangs
stanks104917703_stanks
starts65423123_starts
stats55933363_sta_ts
stents65019453_stents
stints65119763_stints
stunts65615253_stunts
tacts76524123__tacts
taints64520533__taints
tangs65028343__tangs
tanks94624733__tanks
tans46154813__tan_s
tanto55724943__tanto
tarts57242023__tarts
tats46858133__ta_ts
taunts65715663__taunts
tauts56125513__tauts
tenants7311013tenants
tents56434213__tents
tetanus737933tetanus
tints56030923__tints
titans63414913titan_s
titrants838483titrants
truants738163truants
tyrants1037453tyrants
wants87932213__wants
witans93412933witan_s

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.1561145455.1
2DLD Change Limit1340272337.33018284.7
3Display Results2332330.0932505.4
 (SQL Overall)1786912337.57923577.1
 
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.