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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
teasers7531724(None) 
leasers74717841leasers
tearers75218231tearers
teasels74311311teasels
teaser65421521teaser_
teases65426271tease_s
abasers95311972abasers
beaders104120182beaders
beakers134216872beakers
bearers94619592bearers
beaters94925042beaters
beavers124417322beavers
ceases84427072cease_s
censers94313902censers
chasers123714922chasers
creasers103612832creasers
dealers84118612dealers
debasers11377902debasers
eagers74523682_eagers
easels65914552_easels
eases56041612_ease_s
easters75125682_easters
eaters65535952_eaters
erasers74413942erasers
fearers104815272fearers
feases95422922fease_s
feasters11511562feasters
geysers1135702geysers
greasers93410252greasers
headers113819392headers
healers104319462healers
heapers123616672heapers
hearers104319782hearers
heaters104225222heaters
heavers133717192heavers
lasers64925702_lasers
leaders83819602leaders
leakers113415422leakers
leaners73718172leaners
leapers93716662leapers
leaser65322672leaser_
leases65428112lease_s
leavers103717782leavers
masers84623452_masers
meaners94415242meaners
peases85229472pease_s
pleasers104010292pleasers
rasers64526782_rasers
readers83823772readers
reamers94221082reamers
reapers93520452reapers
rearers74323562rearers
reavers108320742reavers
sealers74323552sealers
seamers94719432seamers
seaters74028942seaters
seisers73816392seisers
stealers83412202stealers
steamers103410872steamers
tabers84621572t_abers
takers103923742t_akers
talers64628142t_alers
tamers84224032t_amers
tapers84025812t_apers
tasters74225642t_asters
taters64932202t_aters
tawers94118602t_awers
taxers134015282t_axers
teachers133212392teachers
teamsters1135972teamsters
tearer64822902tearer_
tears55436462tea__rs
tease55428712tease__
teased74721152tease_d
teasel63914982tease_l
teaselers9165842teaselers
teazels16406892teazels
tedders94010232tedders
teemers95012902teemers
teeners74415452teeners
teeters74018302teeters
telfers10299072telfers
tellers73717592tellers
tempers113513012tempers
tenders83719722tenders
tenners74014922tenners
tenser64919432tenser_
tenses64722552tense_s
tensors72712372tensors
tenters73921102tenters
termers95414502termers
terser67317822terser_
tessera736332tessera
testers74124542testers
tethers103815312tethers
tetters74320472tetters
texases1437572texase_s
thalers106212262thalers
thawers13428482thawers
theaters114211902theaters
toasters83912722toasters
tossers74713502tossers
tracers94917842tracers
traders84316952traders
trashers113013642trashers
treaders93311842treaders
treaters83615842treaters
tussers74313562tussers
vealers103214292vealers
versers103813522versers
weaners104613832weaners
wearers104615902wearers
weasels10468502weasels
weavers133714462weavers

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.376475242.0
2DLD Change Limit1076711143.42031482.7
3Display Results1141140.0462478.3
 (SQL Overall)1786911143.84246509.9
 
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.