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 “offenders” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 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
offenders164340(None) 
offender1543721offender_
defenders1436362defenders
fenders113717262__fenders
offences1645022offence_s
offended1643652offende_d
offends14234292offend__s
offenses1443832offense_s
offerers1434932offe_rers
affecters1763933affecters
amenders11288353_amenders
ascenders1235693ascenders
attenders1045283attenders
benders104021063__benders
blenders115211003_blenders
calenders1237403calenders
cofounders1643333cofounders
commenders17137143commenders
contenders1348623contenders
defender1337293defender_
degenders1236083degenders
effecters1764323effecters
effendis1542513effend_is
emenders11319033_emenders
enders74324053___enders
engenders1145303engenders
expenders19145963expenders
extenders17125673extenders
feeders113712863__feeders
fencers123810623__fencers
fender103718723__fender_
fielders12156773_fielders
finders113717873__finders
flensers1135463_flensers
flinders12439273_flinders
fomenters1437853fomenters
founders123911683_founders
funders113813943__funders
genders93616783__genders
intenders10219373intenders
lavenders1334753lavenders
lenders84419653__lenders
menders103818803__menders
offence1545353offence__
offend13365663offend___
offending1744093offending
offense1343683offense__
offerer1335543offe_rer_
offerors1443533offe_rors
offers12349963off___ers
officers1643803off_icers
offsides1543393offside_s
oftener1035923often_er_
oleanders1035573oleanders
openers9339493o_pen_ers
orienters937633orienters
refunders1334973refunders
renders83821673__renders
senders83022353__senders
softeners1245133soften_ers
spenders113211743_spenders
tenders83719723__tenders
venders113717003__venders

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 Filter1786911486410.420425454.8
2DLD Change Limit148641635.89325223.3
3Display Results63630.0302100.0
 (SQL Overall)178691636.34328171.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.