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

71 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
flickering204409(None) 
bickering1837662_bickering
blinkering1744322blinkering
clinkering1745232clinkering
dickering1737462_dickering
flichtering2042682flichtering
flickeringly2561232flickeringly
flicking184110042flick__ing
flittering1486502flittering
lackering1639372_lackering
nickering1636572_nickering
slickening1743902slickening
snickering1744862snickering
whickering2343412whickering
blackening1944793blackening
blistering13107063blistering
blithering16116123blithering
checkering2244403checkering
chickening2244133chickening
clicking173610983click__ing
cockering1839693_cockering
cricketing1944033cricketing
dackering1737383_dackering
daikering1536103dai_kering
filtering13199723f_iltering
fingering1439193f_ingering
flackeries1955423flackeries
flacking184311793flack__ing
flattering1498743flattering
flecking18408233fleck__ing
fleering123811283fl__eering
flicker163610623flicker___
flickered1943753flicker_ed
flickers17338883flicker__s
flickery20365103flicker__y
flocking183410873flock__ing
flowering1636053fl_owering
flustering14105933flustering
fluttering14106293fluttering
frittering14105623frittering
glimmering1643713glimmering
glistering12106423glistering
glittering1296003glittering
lackeying1934923_lackeying
lechering1538443_lechering
lichening1545673_lichening
lickerish1844423_lickerish
licking144118283_lick__ing
likening13246893_li_kening
limbering1488793_limbering
lingering11310513_lingering
lippering14217883_lippering
littering102411983_littering
livering122012383_li_vering
nickeling1645393_nickeling
officering1942143offic_ering
pickeering1943533_pickeering
picketing1835683_picketing
puckering1835883_puckering
quickening2643163quickening
sickening1635993_sickening
slackening1744343slackening
slicking153712593slick__ing
slithering1496893slithering
slivering1338083sli_vering
suckering1638103_suckering
thickening2043283thickening
ticketing1635633_ticketing
tinkering1437703_tinkering
tuckering1635693_tuckering
ulcering1139333ul_c_ering

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603715.87323940.6
3Display Results71710.0302366.7
 (SQL Overall)178691716.05929491.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.