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

129 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
flowering163605(None) 
glowering1435651glowering
lowering122210911_lowering
beflowering2042762beflowering
bowering142911712_bowering
cowering142514032_cowering
deflowering1952652deflowering
dowering132510612_dowering
fleering123811282fl_eering
flooring12259882flo_oring
flouring123010142flo_uring
flowerier1544272flowerier
flowerily1842992flowerily
flowing143411762flow__ing
powering142210802_powering
reflowering1843172reflowering
showering1646402showering
towering122610872_towering
altering91917113al_tering
answering1345803answering
blowing133813053blow__ing
boweling143410683_boweling
brokering1636283brokering
chowdering2044163chowdering
clavering1538373clavering
clobbering17103933clobbering
closeting1236183closeting
closuring1255173closuring
cloturing1245473cloturing
clouring112811273clo_uring
clowning14307253clow_ning
cohering142413833_cohering
coopering142611323coopering
covering142215723_covering
doweling13279763_doweling
embowering1863413embowering
empowering1863253empowering
faltering132211113faltering
fathering161010093fathering
festering132413173festering
fettering132310513fettering
fevering152510083f_evering
filtering13199723filtering
fingering1439193fingering
flaring114116803fl__aring
flattering1498743flattering
flavoring1665113flavoring
flawing143812563flaw__ing
fleecing14347573fl_eecing
fleeing113511293fl__eeing
fleeting122910323fl_eeting
flexing18358993fl__exing
fleying14329873fl__eying
flickering2044093flickering
flittering1486503flittering
floating123111883flo_ating
floccing16306033flo_ccing
flocking183410873flo_cking
flogging14329173flo_gging
flooding13238963flo_oding
floorings13245093flo_orings
flopping16388773flo_pping
florin9312653flo__rin_
florins10311643flo__rins
flossing12247903flo_ssing
flouncing1533903flouncing
floundering1642483floundering
flouting122610473flo_uting
flower124815503flower___
flowerage1643103flowerage
flowered1546013flower_ed
flowerer1435453flower_er
flowerers1544503flowerers
floweret1448083flower_et
flowerets1544043flowerets
flowerful1852283flowerful
floweriest1644533floweriest
floweriness1743073floweriness
flowerlike2042113flowerlike
flowerpot1752863flowerpot
flowers133413173flower__s
flowery16327783flower__y
flustering14105933flustering
fluttering14106293fluttering
foddering1535163foddering
forewing1539003f_orewing
fostering132411263fostering
fowling143713113f_ow_ling
frowning15307833frow_ning
frowsting1634683frowsting
fullering1336653fullering
glowing123211793glow__ing
hollering1337743hollering
homering141512073_homering
hoovering1635753hoovering
hovering151911143_hovering
imbowering1863053imbowering
impowering1863323impowering
lagering102212313_lagering
lawyering1655213_lawyering
layering122310353_layering
leering83417643_l_eering
levering122212503_levering
livering122012383_livering
loitering1039683_loitering
loppering14237283_loppering
louring83916503_lo_uring
lowing104623273_low__ing
moldering1367863moldering
nonflowering1951723nonflowering
overing111918053__overing
plowing133111723plow__ing
powdering16246503_powdering
repowering1645273repowering
rogering10310273_rogering
roweling122811123_roweling
scowdering1743983scowdering
sewering122411093_sewering
showring1548323show_ring
skewering1744633skewering
slavering1338723slavering
slivering1338083slivering
slobbering15103883slobbering
slowing112814743slow__ing
sobering111912783_sobering
soldering1169033soldering
toweling122910373_toweling
troweling1376363troweling
ulcering1139333ul_cering

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.436409841.7
2DLD Change Limit1486411297.01621186.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.49823831.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.