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

74 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
fiscally164607(None) 
dismally1446512dismally
distally1239552distally
festally1437542festally
filially1447002filially
finally13310102fi_nally
finically1747952finically
fiscal1139332fisca_l_
fiscals1238002fisca_ls
focally15188552f_ocally
misally121111062mis_ally
miscall1139642miscall_
miscalls1239002miscalls
rascally1347732rascally
visually1465492visually
apically1539833apically
basally1237963bas_ally
basically1648033basically
buccally1744623buccally
caecally1547703caecally
casually1356823casually
cecally1459393_cecally
civically1946563civically
costally1339723costally
ducally13257413_ducally
epically15310583epically
facially1637643facially
fatally1339893f_atally
faunally1445433faunally
feudally1554823feudally
fickly18318533fi_c_kly
fiducially1952143fiducially
figurally1643633figurally
filly114424903fi___lly
filmically2044933filmically
fiscalist1446573fiscalist
fishable1637593fishable
fishily1637643fis_hily
fitfully1744993fitfully
florally1447033florally
formally1638243formally
frugally1544403frugally
fugally1435603f_ugally
ideally1137793_ideally
kissably1744073kissably
laically1338983laically
lineally1137793lineally
locally12179723_locally
mesally12119793mes_ally
mesially13119083mesially
mesically16310093mesically
miscalled1447443miscalled
miscaller1346283miscaller
miscarry1544473miscarry
musically1647853musically
nasally1057443nas_ally
piscary1437423pisca_ry
postally13310273postally
ritually1167483ritually
sally85129713__s_ally
scall74420373__scall_
scalls84218203__scalls
scaly104718723__sca_ly
signally1246533signally
tidally1137933ti_dally
usually1066063_usually
vestally1437413vestally
vicarly1536463vi_carly
virally1339653vi_rally
viscerally1853393viscerally
viscidly1753303viscidly
vitally1339673vi_tally
vocally15188343_vocally
zircaloy2241873zircaloy

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 Filter1786911461620.410435831.7
2DLD Change Limit146162746.43622710.1
3Display Results74740.0302466.7
 (SQL Overall)178691746.87625987.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.