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

63 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
suspenses1110641(None) 
suspense10135741suspense_
suspenser11114971suspenser
suspensers12114321suspensers
dispenses121210762dispenses
spenses92913572__spenses
subsenses1147472subsenses
suspended13104512suspended
suspender12115092suspender
suspenders1384582suspenders
suspends1145142suspen_ds
suspensor1193382suspensor
suspensors1283662suspensors
asperses104111673_asperses
dispense11129783dispense_
dispensed13158773dispensed
dispenser12128323dispenser
dispensers13146743dispensers
disperses121211773disperses
expenses17138373_expenses
missenses1148033missenses
responses1147453responses
senses63923943__s_enses
sixpences2043633sixpences
speises93813933__speises
spences113413923__spences
spense83912433__spense_
suaveness1247703suaveness
subgenres1245533subgenres
subgenuses1343633subgenuses
subleases1148653subleases
submerses1348003submerses
subpenaed1444773subpenaed
subpenas1246903subpen_as
subphases1645753subphases
subsense1046963subsense_
subspecies1644743subspecies
subvenes1339633subven_es
successes1345643successes
summonses1344543summonses
supersex1738423su_persex
supines94216383su_pin_es
suppleness1444453suppleness
supposes1238203su_pposes
suppresses1446253suppresses
surceases1157473surceases
sureness8912903su_reness
surpasses1145533surpasses
surpluses1155433surpluses
surprises1137433surprises
suspected1444383suspected
suspects1254863suspe_cts
suspend1036013suspen__d
suspenseful1661513suspenseful
suspenseless1381703suspenseless
suspension1253803suspension
suspensions1353843suspensions
suspensive1553873suspensive
suspensories14102083suspensories
suspensory15112663suspensory
suspires1038203susp_ires
susses64221053sus___ses
tuppences1543963tuppences

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.516346300.4
2DLD Change Limit148641636.73322076.5
3Display Results63630.0331909.1
 (SQL Overall)178691637.28224538.7
 
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.