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

52 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
vaporless144316(None) 
paperless1345832paperless
savorless1243212savorless
vaporers1336242vapor_ers
vaporises14209452vaporises
visorless1243142visorless
airless73712043_a_irless
armorless1143483armorless
barless94317003ba__rless
capless114312763cap__less
carless95118493ca__rless
colorless1145683colorless
doorless936713_doorless
earless74316073ea__rless
errorless942813errorless
flavorless1642183flavorless
floorless1243793floorless
gapless10349993gap__less
hairless1157413ha_irless
hapless123311333hap__less
harborless1542663harborless
humorless1442963humorless
mayoress1344383mayor_ess
motorless1145723motorless
napless93110283nap__less
oarless73913373oa__rless
odorless934173_odorless
portless10310643__portless
sapless93313443sap__less
spotless1037043_spotless
tapeless10218643tap_eless
valorises122210183valorises
valueless1242843valueless
valveless1543163valveless
vapidness15144423vapidness
vapored1336923vapor_e_d
vaporer1236983vapor_e_r
vaporings1544093vaporings
vaporise13209633vapor_ise
vaporised15216953vaporised
vaporish16246733vapor_ish
vaporizers24244113vaporizers
vaporizes23228523vaporizes
vaporlike1843433vaporlike
vaporous1346483vapor_ous
vapors113812693vapor___s
vapourers1443373vapourers
varlets10411573va__rlets
vowless13246603v__owless
warless104015103wa__rless
waterless1238013waterless
weaponless1542003weaponless

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.1561145455.1
2DLD Change Limit148641527.22020587.4
3Display Results52520.0163250.0
 (SQL Overall)178691527.39224173.6
 
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.