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

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

97 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
dieters8321643(None) 
deters74724681d_eters
diesters92513601diesters
dieter73516771dieter_
diethers1257451diethers
dimeters11411091dimeters
bisters93922612bisters
biters83925242bi_ters
bitters94920362bitters
citers85022982ci_ters
darters84017602darters
daters74827372d_aters
deers64930522d_e_ers
defers105116942d_efers
deicers103612732deicers
deter65028042d_eter_
dialers83614302dialers
diameters1247602diameters
diapers104713912diapers
diasters92913182diasters
dibbers124013172dibbers
dicers94720742di_cers
dickers144117662dickers
dienes75719902diene_s
diesels8429142diesels
dieses75218692diese_s
diester83013682diester_
dietary1158662dietary
dieted83115492diete_d
diether1147442diether_
diets66026642diet__s
differs14339972differs
digesters11257882digesters
diggers104413392diggers
dikers114418792di_kers
dilaters92513062dilaters
diluters9288112diluters
dimers94321092di_mers
dimeter10411892dimeter_
dimmers123811562dimmers
diners75525952di_ners
dingers94321382dingers
dinners83915442dinners
diopters1137692diopters
dippers123615182dippers
diptera1037212diptera
dites66339152di_te_s
dithers114016152dithers
divers105024962di_vers
diverters13227872diverters
doters74423912d_oters
dotters83715972dotters
drifters12417912drifters
duelers83412052duelers
dusters84918362dusters
filters103816552filters
fitters104517752fitters
hinters103719582hinters
hitters104717592hitters
inters64328052_inters
jilters144211962jilters
jitters144314472jitters
kiesters123310152kiesters
kilters113813602kilters
kiters105218592ki_ters
lifters104313782lifters
linters73822632linters
listers74026532listers
liters65429882li_ters
litters73422572litters
meeters94714542meeters
meters85625832_meters
milters93619092milters
minters93822472minters
misters93927512misters
miters84328782mi_ters
niters64624212ni_ters
peters86624592_peters
piecers114112252piecers
quieters17248732quieters
rievers104311452rievers
rioters73615522rioters
ritters74020622ritters
riveters11228162riveters
sifters103714792sifters
sinters74024082sinters
sisters73721592sisters
sitters74221552sitters
teeters74018302teeters
tilters73315952tilters
tinters74221112tinters
titers64526412ti_ters
titters74219622titters
ureters7311822ureters
viewers1337172viewers
wieners103212482wieners
winters103720482winters

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671973.44031299.7
3Display Results97970.0303233.3
 (SQL Overall)178691973.84346497.8
 
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.