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

106 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
assoiled93501(None) 
assailed945321assailed
abseiled1144732abseiled
assailer844822assailer
assoil688542assoil__
assoils776662assoil_s
assorted956602assorted
soiled73822472__soiled
spoiled104811352_spoiled
unsoiled92412082unsoiled
wassailed1343152wassailed
abscised1364133abscised
absolved1443133absolved
absorbed1344263absorbed
adjoined1743513adjoined
adsorbed1243443adsorbed
ailed66240283a___iled
aisled74516183ais__led
anviled1138943a_nviled
ariled75620323a__riled
ascribed1374693ascribed
aspired1068173a_spired
assail6610153assail__
assailers943983assailers
assails769093assail_s
assaulted1042583assaulted
assayed1135593ass_ayed
assembled1443693assembled
assented957513assented
asserted957903asserted
assessed945023assessed
asshole1046793asshole_
assholes1146743assholes
assigned1044633assigned
assisted936233assisted
assize1538633ass_ize_
assizes1638453ass_izes
asslike1137373asslike_
associated13114703associated
assoiling1045353assoiling
assoilment1254093assoilment
assorter866673assorter
assuaged1044383assuaged
assumed1065293ass_umed
assured858373ass_ured
asswaged1343333asswaged
astonied978983astonied
availed1135973a_vailed
avoided1235553a_voided
besmiled1335493besmiled
boiled95020953__boiled
broiled103811423_broiled
cassoulet1155333cassoulet
coiled95123933__coiled
despoiled1344653despoiled
doiled84817293__doiled
ensiled82611433ens_iled
ensouled935833ensouled
entoiled968283entoiled
foiled104618403__foiled
hassled11358303hass__led
insouled936113insouled
lassoed8408743lasso__ed
misfiled14278653misfiled
moiled94318863__moiled
oiled64429473___oiled
parboiled1445223parboiled
rassled83310453rass__led
reassailed1143333reassailed
reboiled11349393reboiled
recoiled113613213recoiled
reoiled84316853_reoiled
resailed93613063resailed
resiled84621983res_iled
resoled84119283reso_led
roiled74320053__roiled
sailed74327763__sailed
scowled13398183_scowled
shoaled113810973_shoaled
shooled115212663_shooled
skoaled12226053_skoaled
smiled93716433__smiled
snailed83811923_snailed
snooled84513933_snooled
soled65835173__so_led
souled75419823__souled
speiled104412123_speiled
spiled94621993__spiled
spoiler93310683_spoiler
spooled104613523_spooled
stoled74521593_sto_led
stooled84313893_stooled
subsoiled1245453subsoiled
tasseled935593tass_eled
tasselled1044633tasselled
toiled74420323__toiled
topsoiled1242643topsoiled
unassailed1142913unassailed
unboiled112410373unboiled
uncoiled112512683uncoiled
unfoiled12249723unfoiled
unoiled82415473_unoiled
unspoiled12255563unspoiled
upboiled13194853upboiled
upcoiled13215183upcoiled
wassailer1242783wassailer

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621067.42319690.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.62223444.1
 
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.