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

62 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
specially164734(None) 
especially1744991especially
spacially1645651spacially
specialty1644301specialty
serially11912842s_erially
socially1338542s_ocially
spatially1446792spatially
special11310302specia_l_
specialer1344732specialer
speciality1746332speciality
specials1238032specia_ls
spectrally1744852spectrally
aerially11911913_aerially
apically1539833apic_ally
caecally1547703caec_ally
cecally1459393_cec_ally
crucially1645443crucially
decimally1745613_decimally
epically15310583epic_ally
epochally1943413epochally
especial1246293especia_l_
facially1637643_facially
genially12129523_genially
glacially1544583glacially
imperially1746843imperially
medially14129323_medially
menially131111093_menially
mesially13119083_mesially
optically1649903optically
penally121111773_pe_nally
racially1339623_racially
rectally1339713_rectally
scenically1747943scenically
seminally1458803s_eminally
sexually1845613s_exually
sociably1546793s_ociably
sonically14310953sonically
spacial1138763spacia_l_
specialest1445573specialest
specialise1446603specialise
specialism1646813specialism
specialist1448343specialist
specialize2347193specialize
speciate12209583specia_te
speciated14207543speciated
speciates13229233speciates
specifically2453473specifically
specify1764993speci__fy
speciously1746343speciously
spectacle1544083spectacle
specularly1753403specularly
spherically2146943spherically
spicily1438653spici__ly
spinally1338023sp_inally
spirally1348023sp_irally
spousally1442893spousally
sterically15410493sterically
stoically1449673stoically
suicidally1653523suicidally
supernally1546773supernally
uncially1339073_uncially
venially1499423_venially

Search took 9 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.440406115.9
2DLD Change Limit148641628.31017887.0
3Display Results62620.0331878.8
 (SQL Overall)178691628.78320345.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.