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 “fallowing” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
fallowing166643(None) 
allowing12369091_allowing
fellowing1655921fellowing
following1665751following
hallowing1676941hallowing
sallowing1357381sallowing
tallowing1366291tallowing
wallowing1666071wallowing
alloying12339142_alloying
balloting1238382balloting
bellowing1547192bellowing
billowing1545872billowing
falling113621582fall__ing
farrowing1645872farrowing
flowing143411762f__lowing
followings1752822followings
galloping1356252galloping
halloaing1387032halloaing
halloing121510072hallo_ing
hallooing1366342hallooing
hollowing1675932hollowing
mellowing1545892mellowing
pillowing1545492pillowing
shallowing1744112shallowing
swallowing1743042swallowing
walloping1545592walloping
willowing1645322willowing
yellowing1655072yellowing
allaying12339303_allaying
alleging1038473_alleging
allotting1046503_allotting
alluding1036953_alluding
alluring939073_alluring
allying113011663_all_ying
arrowing1237943_arrowing
avowing1466603_a_vowing
balling104424763ball__ing
ballooning1344723ballooning
blowing133813053__blowing
bolloxing1944773bolloxing
calling103826773call__ing
callousing1344273callousing
callusing1236173callusing
dallying13368493dall_ying
disallowing1643283disallowing
dolloping1344993dolloping
elbowing1435013_elbowing
fabling133413623fabl__ing
factoring1537523factoring
faggoting1543313faggoting
fagoting1336283fa_goting
failing113521333fail__ing
falconine1445173falconine
fallow124713853fallow___
fallowed15127753fallow_ed
fallows133713973fallow__s
faltering132211113faltering
fathoming1844693fathoming
fatling113815683fatl__ing
faulting12237733faul_ting
favoring1596673fa_voring
fellating1339243fellating
felling113321133fell__ing
filleting1335843filleting
filling113520803fill__ing
filliping1544233filliping
flavoring1665113flavoring
flawing143812563f__lawing
flooding13238963f_looding
flooring12259883f_looring
flyblowing225913flyblowing
folioing1237573folio_ing
fullering1336653fullering
fulling114019703full__ing
furrowing1644063furrowing
galleting1137623galleting
galling93921963gall__ing
gallying13328933gall_ying
galoping1258023ga_loping
glowing123211793__glowing
gullwing13304923gull_wing
haloing113814133ha_lo_ing
harrowing1646433harrowing
helloing12159123hello_ing
hilloaing1375433hilloaing
hilloing12158303hillo_ing
holloaing1385793holloaing
holloing12148823hollo_ing
hollooing1385363hollooing
hulloaing1384523hulloaing
hulloing12146703hullo_ing
hullooing1383993hullooing
lalling83519623lall__ing
lolloping1244683lolloping
lowing104623273___lowing
malling103623663mall__ing
marrowing1546663marrowing
narrowing1345603narrowing
palleting1238733palleting
palling104024483pall__ing
plowing133111723__plowing
rallying12289013rall_ying
reflowing1636523reflowing
reglowing1436173reglowing
replowing1537413replowing
sallowish1544943sallowish
sallying12309853sall_ying
salvoing1236423salvo_ing
scalloping1543953scalloping
slaloming1244743slaloming
slowing112814743__slowing
tailoring1036403tailoring
tallaging1146483tallaging
tallying12318833tall_ying
unhallowing1851423unhallowing
upflowing1842933upflowing
walling113520973wall__ing
wallopings1652713wallopings

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411186.14024208.6
3Display Results1181180.0462565.2
 (SQL Overall)1786911186.34228175.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.