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

182 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
flatlings1331582(None) 
fatlings12359301f_atlings
flatlines12268431flatlines
flatling123410011flatling_
catlings113712042_catlings
failings123811012f_ailings
fatling113815682f_atling_
fettlings1353752fettlings
flaggings15285182flaggings
flailing12298922flailing_
flashings16316662flashings
flatlands1364302flatlands
flatline11298922flatlin_e
flatlined13275002flatlined
flatliner12285382flatliner
flatliners13254072flatliners
flatlong12274522flatlong_
flatting123511252flatting_
flutings12357372flut_ings
flytings15304792flyt_ings
lathings12469852_lathings
platings113611362plat_ings
slatings94011722slat_ings
slattings10346072slattings
ablings1038743__ablings
bantlings12216603bantlings
battings114010573_battings
beatings114113233beat_ings
blackings18316763blackings
bladings12337753bla_dings
blaggings14324463blaggings
blastings12347913blastings
blatting114111653blatting_
boatings113710113boat_ings
bottlings12215293bottlings
callings113613833_callings
carlings114015863_carlings
catling104819793_catling_
catlins93818843_catlin_s
chitlings15255903chitlings
claddings1433213claddings
clothings15264433clothings
coatings113811843coat_ings
darlings103710383_darlings
dealings103510703dea_lings
dialings10329823dia_lings
diallings1134993diallings
eanlings9128473_eanlings
eatings84616443_eat_ings
elating83423083elat_ing_
fabling133413623f_abling_
facings134511263f_a_cings
fadings12469303f_a_dings
failing113521333f_ailing_
fairings12388193f_airings
falling113621583f_alling_
farmings14298223f_armings
farthings1635233farthings
fastings124011943f_astings
fating105328673f_at_ing_
fatting113818703f_atting_
feelings12338933f_eelings
feltings12317903felt_ings
fettling1266773fettling_
filings115213073f__ilings
fillings122910503f_illings
firstlings1442523firstlings
fittings12318203f_ittings
flacking184311793flacking_
flagging14329233flagging_
flaking154114493fla_king_
flamines13311643fla_mines
flaming134216443fla_ming_
flamingo14274143fla_mingo
flamingos15293093fla_mingos
flamming16357153flamming_
flanging132710583flanging_
flanking164211083flanking_
flapping16298153flapping_
flaring114116803fla_ring_
flashing153711553flashing_
flatland1264963flatlan_d
flatlets1147373flatl_ets
flatlining1443813flatlining
flattens11357483flatten_s
flavines1437893fla_vines
flavins1338543fla_vin_s
flavorings1762973flavorings
flawing143812563fla_wing_
flaying143914463fla_ying_
fledglings1641093fledglings
fleshings16335383fleshings
fletchings19282863fletchings
flings106715283f___lings
fliting113514613flit_ing_
flitting123010883flitting_
floating123111883float_ing_
flockings19314343flockings
floggings15314123floggings
floorings13245093floorings
fluting113815093flut_ing_
flyings14496063fl__yings
flyting14378553flyt_ing_
foaling113515843foa_ling_
fondlings14224893fondlings
footings12248833foot_ings
footling12239923footling_
foulings12327943f_oulings
fowlings15377243f_owlings
fraggings15324243fraggings
framings14338133fra_mings
frayings15325993fra_yings
frillings13265803frillings
gatings95212823_gat_ings
glazings19325753gla_zings
gratings103910763grat_ings
graylings1433883graylings
kitlings13318103_kitlings
lacings105013653_la_cings
ladings93814133_la_dings
ladling92813393_ladling_
laggings11298403_laggings
lakings124713513_la_kings
lalling83519623_lalling_
landings103110073_landings
lapwings14274973_lapwings
lashings124412253_lashings
lastings94214423_lastings
lathing114315693_lathing_
latinas74416463_lat_inas
latinos73613803_lat_inos
latrines8515013_latrines
lattins74115483_lattin_s
lawings113611473_la_wings
loathings1344213loathings
lutings83311053_lut_ings
mailings113011923_mailings
mallings113413093_mallings
mantlings12207233mantlings
marlings113713493_marlings
matings104516213_mat_ings
mattings11369673_mattings
nestlings1074313nestlings
palings103915823_pa_lings
plaitings12296243plaitings
plankings16326113plankings
plannings12325453plannings
plantings12348403plantings
platinas103610313plat_inas
plating103823073plat_ing_
platting114813033platting_
playthings1942363playthings
plotlines1146823plotlines
railings93412153_railings
ratings84217413_rat_ings
ratlines83815293_ratlines
ratlins73615583_ratlin_s
rattlings10235513rattlings
sailings93513253_sailings
saltings92811253salt_ings
saplings11269803_saplings
scantlings1393313scantlings
seatings93614303seat_ings
settlings1054683settlings
skatings13326993skat_ings
slammings14234123slammings
slashings13316203slashings
slating83724653slat_ing_
slatting94014233slatting_
sparlings12257153sparlings
stablings12256103stablings
starlings10237923starlings
tailings93211673_tailings
tattings9408823_tattings
turtlings10184873turtlings
weaklings1794003weaklings
weanlings1394413weanlings
whalings15256763wha_lings
witlings12328443_witlings
yealings12257703yea_lings
yeanlings1393693yeanlings
yearlings1384203yearlings

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 Limit1486411826.90621523.5
3Display Results1821820.0802275.0
 (SQL Overall)1786911827.42224075.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.