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

149 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
oculist931088(None) 
oculists1037131oculists
couldst1037042couldst
coulis84018762coulis_
cubist104214442_cubist
cultist91412712_cultist
localist101613962localist
occultist1353622occultist
ocularist1177322ocularist
oculi72010792oculi__
oculus8178392oculus_
oralist7619632oralist
populist1248202populist
vocalist131512122vocalist
acutest94410603acutest
alist56136783__alist
aurist65027253_aurist
autist64324943_autist
backlist16910653backlist
biblist11310833biblist
botulism1246473botulism
caulis85320083caulis_
cellist9314423cellist
chutist1239453chutist
cist67244963_c__ist
clast76030583_c_last
clift106422193_c_lift
clipt96324273_c_lipt
coaliest10316223coaliest
coexist1638583coexist
consist9316033consist
coolest9318643coolest
coolish12312523coolish
copyist1439053copyist
cosmist11311333cosmist
couldest1148353couldest
coulisse1045113coulisse
cubism12348703_cubism
cubists11359023_cubists
cubit94122893_cubi_t
cubits103714033_cubits
cuish10313173_cu_ish
culet76040343_cul_et
culets85518513_culets
cullet84727313_cullet
cullis84115993_cullis_
culls75425813_culls_
culms95314193_culms_
cult66541153_cul__t
cultish12139113_cultish
cultism11158003_cultism
cultists10107633_cultists
cults75022553_cults_
curliest102713123_curliest
curst74931023_cu_rst
cutest85820143_cutest
cutis77723763_cutis_
cyclist1438853cyclist
delist74625053_delist
dialist8517763dialist
dualist8614053dualist
duelist8511413duelist
enlist6417043_enlist
fabulist1347673fabulist
fauvist1336663fauvist
feudist1137573feudist
flutist102910783flutist
focalise131210373focalise
formulist14205913formulist
foulest10313313foulest
holist94723213_holist
homilist13410033homilist
idylist1146653idylist
jurist134616393_jurist
list47055343___list
localise101511853localise
localism121310013localism
localists11149793localists
locules92812603locules_
loculi8288253loculi__
loculus9296973loculus_
locust85312343locu__st
loyalist111511133loyalist
lutist64317553_lutist
midlist10312513midlist
modelist11310503modelist
moralist10316663moralist
mulish11311903_mulish
novelist1149453novelist
nudist73813323_nudist
obelise9310173obelise
obelisk1345193obelisk
obelism1138203obelism
oblast8613663o_blast
oboist8312683o_boist
occult1038433occul__t
occultism1552403occultism
occultists1452533occultists
occults1135123occults_
ocelot8813383ocel_ot
ocelots977233ocelots
ocular8610133ocul_ar
ocularists1284963ocularists
oculars948363oculars
odalisk1265373odalisk
odist6421913o__dist
oiliest72817683o_iliest
ologist8313833ologist
onanist7314633onanist
opulent938833opulent
oralism9513763oralism
oralists8611803oralists
osculant1046953osculant
oscules938123oscules_
oust46747443o_u__st
outlast71015443outlast
outsit63620893o_utsit
ovules938223ovules_
owlish1238703o_wlish
oxalis1339223oxalis_
pollist9816603pollist
populism1446073populism
populists1345493populists
pulis74225603_pulis_
purist85525053_purist
realist73225383realist
relist64628413_relist
royalist111311983royalist
ruliest72816433_ruliest
scaliest101714393scaliest
schist11312653sc_hist
sciolist10410233sciolist
sculks123610263sculks_
sculls84613883sculls_
sculps104611753sculps_
sculpt104412693scul_pt
sculpts11377063sculpts
socialist11411393socialist
sodalist9311883sodalist
stylist102110283stylist
titlist7312923titlist
totalist8315583totalist
tourist7313203tourist
tubist83013163_tubist
violist10312143violist
vocalise131510813vocalise
vocalism15159043vocalism
vocalists14108893vocalists
wouldst1134063wouldst

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.1561145455.1
2DLD Change Limit1340271496.62620227.4
3Display Results1491490.0463239.1
 (SQL Overall)1786911496.82826170.3
 
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.