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

138 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
oilcans93681(None) 
oilcan837791oilcan_
oilcamp1343052oilcamp
oilcamps1442162oilcamps
oilcups1143332oilcups
oilman839482oilman_
oilways1334872oilways
silvans10308332silvans
wiccans1434602wiccans
alans55636173_al_ans
ashcans1235183ashcans
billons93013363billons
billycans1642873billycans
calcars11312653calcars
callans94518473callans
cancans11311873cancans
cans65050853___cans
clans75031013_cl_ans
cleans85817053_cleans
colicins12312853colicins
cooncans1246273cooncans
dioxans1555313dioxans
discant103017263discant
discants112912023discants
divans104612393di_vans
diwans105110373di_wans
dolmans10479683dolmans
elans55527753_el_ans
falcons1239123falcons
ficins113513983fi_cins
filches153410723filches
fincas113512073finca_s
firmans12238523firmans
fiscals1238003fiscals
flans85327973_fl_ans
gelcaps1235203gelcaps
glans65125833_gl_ans
gleans75014743_gleans
glucans1045293glucans
glycans1344233glycans
icons76516493_i_cons
iliads7448673_iliads
incant82418513_incant
incants92012803_incants
kalians11310183kalians
kilns95112983kil__ns
lallans74113533lallans
leans55536253__leans
ligans76817733li_gans
lignans8398853lignans
lilacs837483lil_acs
limans84816303li_mans
loans56026463__loans
micas96823053mi_ca_s
mildens10339933mildens
milpas101710273milpa_s
minyans1237263minyans
niacins938543niacins
nicads938333ni_cads
nilgais845203nilgais
nilgaus844003nilgaus
ocas66729633o__ca_s
oceans81211003o_ceans
ocicats11137413ocicats
octans81411143o_ctans
oilcup1044253oilc_up
oilers64721193oil_ers
oiling74925313oil_ing
oilmen848313oilmen_
oils46337973oil___s
oilskins1243873oilskins
oilway1235743oilwa_y
oleins6313523o_leins
ollas54218283o_lla_s
onlays9398713onl_ays
onloads8246673onloads
oolachans14122713oolachans
orcas75918623o_rca_s
orcins83313433o_rcins
organs7912913o_rgans
origans839973origans
orlons6411013orl_ons
orphans1237773orphans
outmans92413283outmans
pecans101515833_pecans
pelicans1238093pelicans
pians75126963pi__ans
picas94626523pi_ca_s
pilafs113511023pil_afs
pilaus84114133pil_aus
pilaws11399433pil_aws
pillars9313493pillars
pitmans11188743pitmans
plans75731273_pl_ans
railcars1045313railcars
reloans7313133reloans
ricins83618703ri_cins
scans74625103__scans
siccan1037593siccan_
silane62718053sil_ane
silanes72517163sil_anes
silicas9310603silica_s
silicons10107163silicons
silvan92810153silvan_
silvas92912183silva_s
simians959203simians
solans64122493sol_ans
soldans83210403soldans
suldans8299723suldans
sultans72411833sultans
sylvans13235893sylvans
tailfans1144553tailfans
ticals83214713ti_cals
tilaks1097353til_aks
tincals93610643tincals
tipcats1137103tipcats
titans63414913ti_tans
titians72710453titians
tolans64319273tol_ans
toucans937583toucans
uhlans937573uhl_ans
ulans54921303_ul_ans
vicars11712263vi_cars
villains1138013villains
villas96117263villa_s
vincas113912453vinca_s
volcano1244613volcano
volcanos1344733volcanos
wiccan1335033wiccan_
wiccas1336543wicca_s
wigans104511703wi_gans
wildcats1444173wildcats
witans93412933wi_tans
xylans1635883xyl_ans
yulans958673yul_ans
zilches21326303zilches
zillahs1935383zillahs
zircons1854963zircons

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 Limit1340271386.31021240.4
3Display Results1381380.0502760.0
 (SQL Overall)1786911386.76626410.1
 
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.