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

130 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
flatlines1226843(None) 
flatline11298921flatline_
flatlined13275001flatlined
flatliner12285381flatliner
flatliners13254071flatliners
flatlings13315821flatlings
fatlings12359302f_atlings
flamines13311642fla_mines
flatlands1364302flatlands
flatling123410012flatlin_g
flavines1437892fla_vines
latrines8515002_latrines
plotlines1146822plotlines
ratlines83815292_ratlines
alanines8314803ala_nines
alines65735223__a_lines
balklines1536743balklines
beltlines1135963beltlines
bluelines1145833bluelines
buntlines11207153buntlines
bustlines11207353bustlines
carlines103521643_carlines
catlings113712043_catlings
catlins93818843_catlin_s
coastlines12125333coastlines
cutlines102413273_cutlines
datelines1088853_datelines
deadlines11138503deadlines
draglines1145993draglines
elatives1139783elat_ives
failings123811013f_ailings
famines123216263f_a_mines
fanzines2036913f_anzines
fascines13310143f_ascines
fatlike142911193f_atlike_
fatling113815683f_atlin_g
fatties103018203f_atti_es
fattiness12239373f_attiness
fealties1139993fealti_es
featlier1136453featli_er
featliest1238363featli_est
felines104718073f__elines
fettlings1353753fettlings
figulines1345043figulines
fishlines15246843fishlines
flabbiness1742523flabbiness
flaggings15285183flaggings
flailing12298923flailin_g
flakiness1636473fla_kiness
flanes94522423fla___nes
flashiness16105283flashiness
flashings16316663flashings
flatfishes1943993flatfishes
flatland1264963flatlan_d
flatlander1452453flatlander
flatlanders1551983flatlanders
flatlet10312253flatl__et
flatlets1147373flatl_ets
flatlining1443813flatlining
flatlong12274523flatlon_g
flatmates1446193flatmates
flatness1138153flat__ness
flattened13185303flattened
flattener12175173flattener
flatteners13164153flatteners
flattens11357483flatten_s
flatting123511253flattin_g
flatulences1692313flatulences
flatuses1137173flat_uses
flatwares1544763flatwares
flatwise1443973flatwise_
flavine1338453fla_vine_
flavins1338543fla_vin_s
flavones1435833fla_vones
floatplanes1651873floatplanes
fluorines1247553fluorines
flutings12357373flut_ings
flytings15304793flyt_ings
frontlines1345193frontlines
frostlines1345193frostlines
gantlines1039333gantlines
gelatines102910533gelat_ines
glassines10278043glassines
graplines1237353graplines
headlines13119013headlines
hoatzines2143823hoatzines
hotlines11811643_hotlines
hyalines14169333hya_lines
isatines8310663isat_ines
jawlines18126363_jawlines
kaolines1239293_kaolines
landlines1039763_landlines
lanolines939983_lanolines
lathings12469853_lathings
latices9313763_lat_ices
latinas74416463_lat_inas
latinos73613803_lat_inos
latrine7715123_latrine_
lattices1038383_lattices
lattins74115483_lattin_s
lauwines1145713_lauwines
lawines103313563_la_wines
malines93625603_ma_lines
marlines103818713_marlines
opalines10311423opa_lines
outlines82418093_outlines
palatines11313033palat_ines
patines95225763_pat_ines
platanes102711883plat_anes
platies93722543plat_i_es
platinas103610313plat_inas
platings113611363plat_ings
plotline1037643plotline_
potlines10714213_potlines
pralines102217723pra_lines
ratines75328583_rat_ines
ratline74517803_ratline_
ratlins73615583_ratlin_s
salines74029413_sa_lines
saltines82917793salt_ines
setlines8312743_setlines
slatiness92511363slat_iness
slatings94011723slat_ings
slattings10346073slattings
smaltines1136993smaltines
taglines92210833_taglines
tramlines1139843tramlines
traplines11310373traplines
trotlines939103trotlines
valines104520213_va_lines

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.423422437.4
2DLD Change Limit1486411306.06024528.2
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.52927368.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.