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

124 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
assorter86667(None) 
asserter877571asserter
assorted956601assorted
assorters965731assorters
aborter939932a_borter
absorber1254312absorber
adsorber1143502adsorber
assenter867702assenter
asserted957902asserted
asserters956392asserters
assertor865722assertor
assister836752assister
assort64916382assort__
assorts73310152assort_s
assurer767792assur_er
resorter8312182resorter
shorter103515502_shorter
snorter74412662_snorter
sorter64425092__sorter
sporter93616552_sporter
abhorrer1343393abhorrer
aborted10310423a_borted
aborters1038573a_borters
absenter1086773absenter
absoluter1142923absoluter
absolver1343693absolver
absorbed1344263absorbed
absorbers1353983absorbers
absurder11134363absurder
accorder1395233accorder
accouter1245363accouter
adopter1036763a_dopter
adorer74713453a_dor_er
adorner8246983a_dorner
adroiter946193adroiter
adsorbed1243443adsorbed
adsorbers1243263adsorbers
alerter72111513a_lerter
allotter866473allotter
armorer9259913armor_er
ashore9414613ashor_e_
asperser10408303asperser
aspirer967903aspir_er
assailer844823assailer
assaulter942753assaulter
assayer1035573ass_ayer
assented957513assented
assenters966993assenters
assentor865293assentor
assert64922583assert__
assertors965973assertors
asserts74311793assert_s
assigner944853assigner
assisted936233assisted
assisters936353assisters
assistor844823assistor
assoiled935013assoiled
assorting1037303assorting
assortment1254693assortment
assuager944343assuager
assumer965363ass_umer
assure6610773assur_e_
assured858373assur_ed
assurers866313assur_ers
assures7611403assur_es
assuror754203assur_or
aster55434893a_s__ter
averter102410553a_verter
cavorter1335783cavorter
deporter1169393deporter
deserter91211603deserter
disorder1038133disorder
distorter1048403distorter
escorted1136703escorted
exhorter1845353exhorter
exporter1737363exporter
extorter1546513extorter
importer12308913importer
inserter82312133inserter
lassoer7379383lasso__er
masseter1037063mass_eter
misorder1147283misorder
missorted1247033missorted
passover13135533passo_ver
porter84224413__porter
reassorted1144363reassorted
reporter10411423reporter
resorted9313493resorted
resorters939693resorters
retorter8410733retorter
savorer1057883savor_er
savorier1136643savorier
scooter93312873_scooter
scorer84818253_scor_er
scorner9259763_scorner
scoter83815483_sco_ter
scouter93313323_scouter
shooter103013993_shooter
shorted113614403_shorted
shorten103511413_shorten
shouter103213083_shouter
skirter11338483_skirter
slotter73314453_slotter
smarter94113133_smarter
snorer64316763_snor_er
snorted83813493_snorted
snorters83410583_snorters
softer94015313__softer
sorer56236583__sor_er
sorner64720393__sorner
sorted74523713__sorted
sorters74221133__sorters
souter64225923__souter
sported104015433_sported
sporters103714063_sporters
sportier102010053_sportier
spotter94514883_spotter
spouter94213223_spouter
spurter94013003_spurter
starter73817883_starter
storer64721673_stor_er
stouter74012053_stouter
swotter10399473_swotter
unsorted9312513unsorted

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621246.50022486.5
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.71926594.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.