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

198 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
oilcan83779(None) 
oilcans936811oilcans
oilman839481oilman
oilcamp1343052oilcamp
oilcup1044252oilcup
oilmen848312oilmen
oilway1235742oilway
siccan1037592siccan
silvan92810152silvan
wiccan1335032wiccan
aidman92410623aidman
airman82414223airman
alan46844083_al_an
ashcan1135843ashcan
billon83713833billon
billycan1543223billycan
calcar10312753calcar
callan83619603callan
can57760143___can
cancan10314103cancan
cilia73016763cilia_
circa9311403circa_
clan65633923_cl_an
clean75420413_clean
colicin11313743colicin
cooncan1147233cooncan
dioxan1465773dioxan
discant103017253discant
divan96114843di_van
diwan95712553di_wan
dolman95312403dolman
elan46734243_el_an
eolian6312593eolian
exilian1446963exilian
falcon11310293falcon
ficin103516723fi_cin
fila74729133fil_a_
filar84819293fil_ar
filch134813323filc_h
filial93013253filial
finca104714503finca_
fincas113512073fincas
firman112211343firman
fiscal1139333fiscal
flan76134183_fl_an
foilsman1353773foilsman
gelcap1136213gelcap
glean65818203_glean
glucan936183glucan
glycan1234903glycan
hila76228353hil_a_
hilar85418143hil_ar
hitman112710223hitman
icon66922043_i_con
ilea45931463_ilea_
ileac75814173_ileac
ileal56118083_ileal
ilia46026823_ilia_
iliac75013493_iliac
iliad64613463_iliad
ilial55317843_ilial
ilka87215153_ilka_
incant82418503_incant
kalian10312163kalian
kiln85620983kil__n
lallan63414173lallan
lean46345243__lean
ligan67920283li_gan
lignan75510323lignan
lilac7311073lil_ac
lilacs837483lilacs
liman75921603li_man
loan47436453__loan
mailman1137733mailman
mica86428253mi_ca_
micas96823053mi_cas
midcap1336473midcap
milch124413373milc_h
milden94113153milden
milia72719573milia_
milkman1544913milkman
milpa92111403milpa_
milpas101710273milpas
minyan1138173minyan
niacin8310223niacin
nicad8312613ni_cad
nilgai734883nilgai
nilgau735113nilgau
oca56731733o__ca_
ocas66729633o__cas
ocean71212963o_cean
ocicat101412813ocicat
octan71313483o_ctan
oidia6314953oidia_
oil37452053oil___
oilcamps1442163oilcamps
oilcups1143333oilcups
oiled64429473oil_ed
oiler54628283oil_er
oilers64721193oilers
oilier64417233oilier
oilily93111723oilily
oiling74925313oiling
oils46337973oil__s
oilskin1144473oilskin
oilways1334873oilways
oily77932253oil__y
olden65114853o_lden
olea46532723o_lea_
olein5316003o_lein
olla44821173o_lla_
ollas54218283o_llas
onlay84212943onl_ay
onload7268633onload
oolachan13133353oolachan
orca65522773o_rca_
orcas75918623o_rcas
orcin72716573o_rcin
organ6915393o_rgan
origan7310693origan
orlon5415003orl_on
orphan1137733orphan
outman83115033outman
outran63218893outran
pecan91919033_pecan
pelican1139433pelican
pian66136093pi__an
pica85831493pi_ca_
pical95524373pi_cal
picas94626523pi_cas
pilaf103923483pil_af
pilar75221503pil_ar
pilau73618523pil_au
pilaw103913743pil_aw
pilea75123953pilea_
pillar8314023pillar
pitman102412123pitman
plan65833943_pl_an
plica9613373plica_
plicae10410953plicae
plical10411683plical
railcar945483railcar
reloan6415693reloan
ricin74620213ri_cin
scan65530453__scan
silane62718053sil_ane
silica8311243silica_
silicas9310603silicas
silicon9117533silicon
silken104410853silken
silva82714023silva_
silvae92811093silvae
silvans10308333silvans
silvas92912183silvas
simian8811163simian
solan55328153sol_an
soldan73511853soldan
sulcal8311273sulcal
suldan72611043suldan
sultan63012593sultan
sylvan12257363sylvan
tailfan1044653tailfan
tical76021493ti_cal
tilak91011553til_ak
tincal83913363tincal
tinman82411143tinman
tipcat10312653tipcat
titan53318173ti_tan
titian62512663titian
titman82711003titman
tolan55124013tol_an
tollman935863tollman
toucan838193toucan
uhlan849113uhl_an
ulan46527393_ul_an
ulpan7310123_ulpan
vicar10513863vi_car
villa85321233villa_
villae95615383villae
villain1038473villain
villas96117263villas
vinca105315163vinca_
vincas113912453vincas
voila84813943voil_a_
volcano1244613volcano
wicca1247253wicca_
wiccans1434603wiccans
wiccas1336543wiccas
wigan95114393wi_gan
wilco1039443wilc_o
wildcat1346293wildcat
witan83816503wi_tan
woolman1235433woolman
xylan1537463xyl_an
yulan8411493yul_an
zilch19438123zilc_h
zillah1836563zillah
zircon1754953zircon

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 Filter1786911127160.763234195.3
2DLD Change Limit1127161985.19021717.9
3Display Results1981980.0603300.0
 (SQL Overall)1786911986.01329717.4
 
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.