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

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

140 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
fatling11381568(None) 
catling104819791catling
fabling133413621fabling
failing113521331failing
falling113621581falling
fating105328671fat_ing
fatlings12359301fatlings
fatting113818701fatting
flatling123410011flatling
ailing74331012_ailing
bailing103723522bailing
baling94829692ba_ling
balling104424762balling
bantling112612002bantling
bathing134816242bathing
bating95132252bat_ing
batting104422272batting
battling113110492battling
batwing13509812batwing
bawling133813862bawling
butling103516812butling
cabling124017552cabling
calling103826772calling
carling103727072carling
castling11311232castling
catlin83819082catlin_
catlings113712042catlings
catlins93818842catlins
catting103922642catting
darling93418372darling
dartling1039562dartling
dating85326482dat_ing
eagling91113602eagling
eanling81416672eanling
eating75134402eat_ing
facing125321572fa_cing
fadging134210242fadging
fading114821112fa_ding
fagging133714762fagging
failings123811012failings
fairing113614012fairing
faithing1537152faithing
faking145520982fa_king
faming124922972fa_ming
fanning113615072fanning
farcing133514002farcing
farding123716742farding
faring105231282fa_ring
farming133515082farming
farthing1538072farthing
farting114120752farting
fashing144918792fashing
fasting114522832fasting
fatlike142911192fatlike
faulting12237732faulting
fawning14409132fawning
faxing175117052fa_xing
faying134521072fa_ying
fazing194418642fa_zing
feeling113617072feeling
felling113321132felling
felting113515212felting
feting104417792fet_ing
fetting113517872fetting
fettling1266772fettling
filing103823762f_iling
filling113520802filling
fitting113516562fitting
flailing12298922flailing
flatline11298922flatline
flatlings13315822flatlings
flatlong12274522flatlong
flatting123511252flatting
fling97023512f__ling
foaling113515842foaling
foiling113317652foiling
fooling113117372fooling
footling12239922footling
fouling113315372fouling
fowling143713112fowling
fueling113615132fueling
fugling124212512fugling
fulling114019702fulling
furling114016562furling
futzing20307902futzing
gabling113514542gabling
galling93921962galling
gaoling93314652gaoling
gating84826952gat_ing
hailing113820692hailing
haling104229782ha_ling
halting114419072halting
hating104929712hat_ing
hatting113920232hatting
hauling113714432hauling
jailing153415842jailing
kitling123313572kitling
ladling92813392ladling
lalling83519632lalling
lathing114315692lathing
mailing102923352mailing
malling103623672malling
malting103219082malting
mantling112012612mantling
marling103322782marling
mating94832912mat_ing
matting103620142matting
mauling103315692mauling
nailing83419962nailing
paling93530132pa_ling
palling104024492palling
parling103823772parling
patting103722342patting
railing83325642railing
rating74938702rat_ing
ratlin64116522ratlin_
ratline74517812ratline
ratlins73615582ratlins
ratting83822362ratting
rattling92510872rattling
sailing83927372sailing
salting84120792salting
sapling103217862sapling
sating74735452sat_ing
staling83925422staling
tabling103216032tabling
tailing82923102tailing
tatting84019522tatting
tattling9259472tattling
titling83715792titling
vailing113817952vailing
vatting113614852vatting
wailing113620902wailing
waling104525302wa_ling
walling113520972walling
wattling12258782wattling
wauling112713112wauling
wawling143810962wawling
witling113215812witling
yawling14369182yawling

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711402.95336461.6
3Display Results1401400.0463043.5
 (SQL Overall)1786911403.37252992.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.