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

111 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
ocicats1113741(None) 
ocicat101412811ocicat_
apicals1159923apicals
bobcats1335993bobcats
boccias13307193boccia_s
cacaos104616183_cacaos
cacas95627983_caca_s
carats85929023_carats
cats66356343___cats
chats105730093_c_hats
cheats114519543_cheats
chicas135916473chica_s
cicada1136413_cicada
cicadas1235993_cicadas
cicala10310053_cicala
cicalas1139303_cicalas
cicale10314503_cicale
cigars9910723_cigars
cists76624533_ci_sts
civets115212543_civets
cleats84919313_cleats
coacts105314333coac_ts
coats75635003_c_oats
cocas95926573_coca_s
cocomats1449403cocomats
combats13311683combats
copycats1745083copycats
cowpats1437713cowpats
cycads14476213_cycads
cycas126513823_cyca_s
dicast9315573_dicast
dicasts1078703_dicasts
dicots94915793_dicots
ducats95011763_ducats
eclats8313033ec_lats
edicts94911703edic_ts
elicits9311233elicits
ericas8315463erica_s
evicts11368553evic_ts
fiats85324483_fi_ats
hepcats1436473hepcats
icecaps1343863icecaps
icicles1135943icicles
ikats95311153__ikats
lichts113712383_lichts
loricate10310663loricate
loricates11310123loricates
micas96823053_mica_s
mudcats1236223mudcats
muscats1138933muscats
nicads938333_nicads
oats46554213o___ats
obias76116863obi_a_s
obits74617553obi__ts
ocas66729633o__ca_s
occiputs1442483occiputs
occults1135123occults
occurs10136553oc_curs
oceans81211003oc_eans
ocelots977233ocelots
ocreate93711743ocreate
octads987333oc_tads
octans81411143oc_tans
octants9128733octants
octets839403oc_tets
oculars948363oculars
odists749853odi_sts
offcast1544473offcast
offcasts1643013offcasts
offcuts1542573offcuts
ohias84415573ohi_a_s
oilcans936813oilcans
omits75018263omi__ts
opiate8513463opi_ate
opiates9312143opi_ates
orcas75918623o_rca_s
orgeats838353orgeats
orients7311583orients
origans839973origans
outacts9310213outacts
outcast91013743outcast
outcasts10108683outcasts
outeats72215703outeats
ovisacs1263283ovisacs
oxcarts1634313o_xcarts
oxidants1643933oxidants
oxidate1537023oxidate
oxidates1636333oxidates
picas94626523_pica_s
piccata1345703piccata
picots104616443_picots
plicate11314513plicate
polecats1248833polecats
scats75930603__scats
socials999633soci_als
solicits10311023solicits
sonicate10310933sonicate
sonicates11410383sonicates
spicas104715823spica_s
spicate113214193spicate
ticals83214713_ticals
tipcats1137103tipcats
toccata1144943toc_cata
toccatas1243743toc_catas
toccate1138773toc_cate
tomcats11127773tomcats
toxicants1843833toxicants
tricots9311563tricots
vicars11712263_vicars
wiccans1434603wiccans
wiccas1336543wicca_s

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.423422437.4
2DLD Change Limit1340271116.43620824.6
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.90525878.5
 
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.