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

59 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
abscond124450(None) 
absconds1343591absconds
absconded1543002absconded
absconder1443012absconder
ascend9429732a_scend
abalone938903abalone
aboon74918703ab_oon_
abound9239863ab_ound
abroad9310943ab_road
abscess1133903abscess
abscise1145953abscise
abscised1364133abscised
absconders1542373absconders
absconding1642993absconding
absent84016993abs_ent
absorb1038013abs_orb
absurd935903abs_urd
accord1178843a_ccord
acold86214933a__cold
almond91410433a_lmond
anaconda1143783anaconda
ancon75718233a_ncon_
ancone83916953a_ncone
arson55118833ars_on_
arsons63917213ars_ons
ascends10388203a_scends
ascent84519653a_scent
ascot76522513a_sco_t
ascots85312513a_scots
astony9510523a_stony
astound845503a_stound
bacon95620593_bacon_
bacons104917583_bacons
balcony1435853balcony
basion84315853basion_
basions94213953basions
bausond1044493bausond
beyond1237073_beyond
blond85618373_b_lond
bond75334363_b__ond
cabstand1344413cabstand
descend11248153descend
despond1137513despond
discoed11312483discoed
discoid11311243discoid
discord1139993discord
exscind1743753exscind
gascon9339723gascon_
gascons10289103gascons
mascon103612743mascon_
mascons113411583mascons
obscene1145243obscene
rescind10410393rescind
respond1039113respond
scend85516293__scend
scold85414863__scold
scone74621833__scone
second9411153_second
viscoid1337023viscoid

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 Filter1786911340270.406440125.6
2DLD Change Limit134027595.84322938.0
3Display Results59590.0163687.5
 (SQL Overall)178691596.26528522.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.