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

84 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
assoiling104535(None) 
assailing1036021assailing
abseiling1265342abseiling
assorting1037302assorting
soiling83422322__soiling
spoiling112911552_spoiling
wassailing1443592wassailing
abscising1444943abscising
absolving1543323absolving
absorbing1444483absorbing
adjoining1844033adjoining
adsorbing1344123adsorbing
ailing74331013a___iling
anviling1239743a_nviling
ascribing1444953ascribing
aspiring1138873a_spiring
assailant944383assailant
assaulting1142923assaulting
assaying1236003ass_aying
assembling1542883assembling
assenting1038163assenting
asserting1038663asserting
assessing1045173assessing
assigning1144673assigning
assisting1046183assisting
associating1444863associating
assoil688543assoil___
assoiled935023assoil_ed
assoilment1254093assoilment
assoils776663assoil__s
assuaging1144123assuaging
assuming1135143ass_uming
assuring937773ass_uring
asswaging1443103asswaging
astonying1345233astonying
availing1267283a_vailing
avoiding1336783a_voiding
besmiling1436263besmiling
boiling103819673__boiling
broiling113112013_broiling
coiling103723453__coiling
despoiling1445113despoiling
ensiling9410723ens_iling
ensouling1046003ensouling
entoiling1038483entoiling
foiling113317653__foiling
hassling1236803hass__ling
insouling1036823insouling
lassoing946383lasso__ing
misfiling1537223misfiling
moiling103417663__moiling
oiling74925313___oiling
parboiling1545173parboiling
rassling939013rass__ling
reassailing1244103reassailing
reboiling12149823reboiling
recoiling121412413recoiling
reoiling93217213_reoiling
resailing103314253resailing
resiling93520173res_iling
resoling92916303reso_ling
roiling83220453__roiling
sailing83927373__sailing
scowling1458293_scowling
shoaling123111753_shoaling
shooling123012563_shooling
skoaling13227213_skoaling
smiling103915443__smiling
snailing92912973_snailing
snooling93013473_snooling
soling74226823__so_ling
speiling113612973_speiling
spiling102919703__spiling
spooling113212563_spooling
stooling93113133_stooling
subsoiling1344873subsoiling
tasseling1035853tass_eling
tasselling1145233tasselling
toiling83219023__toiling
topsoiling1343223topsoiling
uncoiling1238993uncoiling
unsmiling1256873unsmiling
upboiling1444633upboiling
upcoiling1444793upcoiling

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 Filter1786911486410.423422437.4
2DLD Change Limit148641847.20320636.0
3Display Results84840.0302800.0
 (SQL Overall)178691847.65623340.0
 
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.