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

141 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
oftener103592(None) 
softener1145611softener
offender1543722offender
offerer1335542offerer
often84611412often__
oftenest1148862oftenest
ofter84116872oft__er
opener83910992o_pener
rottener8216972rottener
softened1235662softened
softeners1245132softeners
after85719793aft__er
aliener71011193aliener
alterer72714013alterer
atoner64817193_atoner
attender935913attender
battener10369403battener
butene8312623butene_
butenes9313033butenes
caterer92815953caterer
congener112412203congener
contemner1347183contemner
contender1239563contender
convener132913163convener
cozener18328953cozener
enterer72015633enterer
evener91010623_evener
extender16146333extender
fainer94717243_fainer
fanner94218183_fanner
fastener11227843fastener
fattener11268113fattener
fawner125910463_fawner
feeder103513843_feeder
feeler93215173_feeler
fencer114613533_f_encer
fender103718723_f_ender
fetter94120383_fetter
fever115617953_f_ever
fewer115216123_f_ewer
feyer115014523_f_eyer
finer85431563_f_iner
fleer86020773_fle_er
flenser1036783_flenser
fomenter1339263fomenter
forever1338953forever
fosterer11239523fosterer
freer86021243_fre_er
fueler94313933_fueler
funner93414103_funner
goldener1045403goldener
greener83111713greener
hastener11259143hastener
hosteler1137283hosteler
integer837993integer
intender93310443intender
intenser8199443intenser
intoner7811673intoner
keener104012843_keener
ketene106613003ketene_
ketenes114813503ketenes
lateener835763lateener
latened8711923latened
listener8158313listener
livener10278943livener
lofter94614723loft__er
loftier1037763loft_ier
loiterer837083loiterer
loosener845633loosener
miterer92511333miterer
moistener1145843moistener
oaten55222403oaten__
oater55433733oat__er
obeyer1135893o_beyer
obscener1244323obscener
obtainer1045793obtainer
obtuser9134453obtuser
octane81411633octane_
octanes91111393octanes
offence1545353offence
offences1645023offences
offend13365663offen_d
offended1643653offended
offenders1643403offenders
offends14234293offends
offense1343683offense
offenses1443833offenses
offer114311383of__fer
offered1436143offered
offerers1434933offerers
offeror1342943offeror
officer1534213officer
oftest91212003ofte_st
omened93711003o_mened
opened94311863o_pened
openers9339493o_peners
orderer8127943orderer
orienter838313orienter
ostler63312193ost_ler
other84219103o_t_her
otter54423973o_t_ter
outdoer849273outdoer
outer55633303out__er
outlier72216143outlier
outliner82412113outliner
owner84613313o__wner
oxter123414093oxt__er
oysterer1136103oysterer
potterer102310263potterer
preener93114833preener
rattener8238533rattener
ravener104110743ravener
retene69224273retene_
retenes76324623retenes
ripener937913ripener
serener73415763serener
shortener1245773shortener
soften9429493soften__
softens10347623soften_s
softer94015313soft__er
steer55423863_ste_er
sterner7411913_sterner
stoner65823203_stoner
teener64717503_teener
tender74121843__tender
tenet55542213__tenet
tenner64117103__tenner
tenor53620253__tenor
tenser64919433__tenser
tenter64623933__tenter
toner55336243__toner
totterer8217793totterer
tuner56022683__tuner
tweener10306833tweener
utterer71910463utterer
wakener1446913wakener
waterer103314083waterer
whitener1435743whitener
widener11318693widener
wiener94513543_wiener
woodener1245763woodener

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.410435831.7
2DLD Change Limit1340271416.81019680.9
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.28324535.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.