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

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

138 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
flichtering204268(None) 
flickering2044092flic_kering
flittering1486502fli_ttering
lightering15246112_lightering
blistering13107063bli_stering
blithering16116123blith_ering
filtering13199723f_i_ltering
flattering1498743fl_attering
flichter1664963flichter___
flichtered1942133flichter_ed
flichters1774173flichter__s
flighting1736103flight__ing
flustering14105933fl_ustering
fluttering14106293fl_uttering
frightening1982683frightening
frittering14105623fri_ttering
glistering12106423gli_stering
glittering1296003gli_ttering
lechering1538443_lech_ering
lichening1545673_lich_ening
lichting14268513_licht__ing
lightening15255053_lightening
littering102411983_li_ttering
slithering1496893slith_ering
alighting1446414alight__ing
altering91917114al___tering
bickering1837664_bic_kering
bittering122511994_bi_ttering
blathering16107584blath_ering
blattering13108714bl_attering
blethering16115934bleth_ering
blighting1635734blight__ing
blinkering1744324bli_nkering
blustering13106184bl_ustering
brightening18102574brightening
butchering1844504butch_ering
catering112019904___catering
cheering143612704___cheering
chittering16107184chi_ttering
ciphering17217704_ciph_ering
clattering13109234cl_attering
clinkering1745234cli_nkering
cloistering1444824cloistering
clustering13116814cl_ustering
cluttering13106834cl_uttering
coinhering1647314coinh_ering
dickering1737464_dic_kering
dithering1499854_dith_ering
eliciting1237774elicit__ing
enlightening1751724enlightening
factoring1537524f_ac_toring
faltering132211114f__altering
fathering161010094f_ath_ering
feathering17108794feath_ering
felicitating1853324felicitating
festering132413174f__estering
fettering132310514f__ettering
fighting162710084f_ight__ing
filching1736114filch___ing
filibustering1961154filibustering
fingering1439194f_i_ngering
flattening14115104fl_attening
fleering123811284fl___eering
flehmening1942244fl_ehmening
flickeringly2561234flic_keringly
flicking184110044flic___king
flinching18245834flinch___ing
flinting123412344fli_nt__ing
flirting12319014fli_rt__ing
flitching18265344fli__tching
fliting113514614fli__t__ing
flitting123010884fli__t_ting
floundering1642484floundering
flowering1636054fl__owering
fostering132411264f__ostering
fracturing1643924frac_turing
frighting1736024fright__ing
furthering1744354furth_ering
glimmering1643714gli_mmering
glistening1294284gli_stening
heightening1952674heightening
helicoptering2162114helicoptering
inhering12913714__inh_ering
jittering17218424_ji_ttering
lackering1639374_lac_kering
lacquering2243604_lacquering
lathering13912254_lath_ering
leathering1488684_leathering
lecturing1237304_lec_turing
leistering1147984_leistering
lettering102112074_l_ettering
lichenin1345054_lich_enin_
lichenins1444844_lich_enins
ligaturing1293064_ligaturing
lighting132811834_light__ing
lightning14286024_light_ning
limbering1488794_li_mbering
lingering11310514_li_ngering
lippering14217884_li_ppering
listening10128954_li_stening
livering122012384_li__vering
lobstering1345124_lobstering
loitering1039684_l_oitering
lustering102711204_l_ustering
mitering113015404_mi__tering
nickering1636574_nic_kering
ochering14219394__och_ering
officering1942144offic__ering
philtering1646254phi_ltering
pickeering1943534_pickeering
picturing1436034_pic_turing
plaistering1444604plaistering
plastering1339244pl_astering
plighting1635564plight__ing
richening1546224_rich_ening
roistering1148584roi_stering
sintering101014804_si_ntering
sistering101213754_si_stering
skittering1535394ski_ttering
slathering14108284slath_ering
slaughtering1752254slaughtering
slickening1743904slic_kening
slighting1436374slight__ing
slipcovering2051244slipcovering
slivering1338084sli__vering
snickering1744864snic_kering
splintering1444294spli_ntering
swithering17105214swith_ering
tightening15153944_tightening
tittering102310314_ti_ttering
tochering1537154_toch_ering
twittering1444584twi_ttering
ulcering1139334ul_c__ering
vouchering1943654vouch_ering
waitering13310714wai__tering
whickering2343414whic_kering
wintering13412364_wi_ntering
withering16108814_with_ering

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191388.07618427.3
3Display Results1381380.0801725.0
 (SQL Overall)1786911388.57920828.9
 
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.