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

49 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
actuality144580(None) 
factuality1843861factuality
actualize2046352actualize
actually1366852actual_ly
mutuality1444742mutuality
actability1749083actability
activity1647593act_ivity
actual8311023actual___
actualities1346823actualities
actualized2245343actualized
actualizes2145903actualizes
actuarial1144973actuarial
actuaries1147573actuaries
actuary1245613actua__ry
actuate9311443actua__te
actuating1239233actuating
actuation11310333actuation
acuity1139373ac_u__ity
amorality1446723amorality
anality10313633a__nality
animality1447803animality
asexuality2053783asexuality
atonality1247073atonality
aurality1139223a_urality
axiality1856763a_xiality
brutality1444123brutality
carnality1447603carnality
casualty1344473casual_ty
causality1445333causality
duality1147973__duality
equality2046993_equality
extrality1967203extrality
factualism1753903factualism
factualist1544753factualist
factualists1653523factualists
factually1744663factual_ly
fatality1438443fat_ality
lethality1545113lethality
natality1139193nat_ality
partiality1546783partiality
punctuality1852963punctuality
quality1938563__quality
sexuality1946073sexuality
tactility1446833tact_ility
tactually1445003tactual_ly
totality1139373tot_ality
virtuality1644303virtuality
visuality1545453visuality
vitality1458113vit_ality

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.453394461.4
2DLD Change Limit148641496.81021826.9
3Display Results49490.0163062.5
 (SQL Overall)178691497.27924548.8
 
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.