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

131 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
flings10671528(None) 
clings95716211clings
filings115213071filings
fling97023511fling_
flints95617451flints
flongs105010491flongs
flyings14496061flyings
lings67135771_lings
slings74618011slings
ablings1038742ablings
agings86312672agings
aligns75312952aligns
alines65735222alines
beings94613032beings
blinds95111612blinds
blinis85313682blinis
blinks124613572blinks
bluings10327962bluings
boings96416872boings
brings94618432brings
clangs95113612clangs
clines84926042clines
cling86424672cling_
clingy12659062clingy
clinks125815062clinks
dings76331402_dings
doings84913182doings
dyings11478132dyings
elints65816422elints
facings134511262facings
fadings12469302fadings
failings123811012failings
faints94818782faints
fangs96224072f_angs
fatlings12359302fatlings
feelings12338932feelings
feigns10407752feigns
feints94813872feints
felines104718072felines
feltings12317902feltings
figs85332642f_i_gs
filing103823762filing_
fillings122910502fillings
finds95424822f_inds
fines86644262f_ines
finings114311772finings
finis86824262f_inis
finks125424222f_inks
finos86226952f_inos
fins75849092f_in_s
firings114112322firings
fixings18347442fixings
flags95321282fl_ags
flanes94522422flanes
flange103411972flange
flanges113413272flanges
flanks133913402flanks
flans85327972flan_s
flicks154512992flicks
flics105418362fli_cs
fliers94417192fliers
flies85630712fli_es
flinch144010102flinch
flinger113710512flinger
flingers123410192flingers
flint87333502flin_t
flinty126112492flinty
flips105117742fli_ps
flirs85518932fli_rs
flirts95411482flirts
flites95122442flites
flits85625222fli_ts
flogs95919962fl_ogs
flong95815682flong_
flung95114582flung_
flunks13469862flunks
flutings12357372flutings
flying134612152flying_
flytings15304792flytings
foins85523382foin_s
foulings12327942foulings
fowlings15377242fowlings
foxings18446962foxings
frigs96019272fri_gs
fringe104013952fringe
fringes113514102fringes
fringy13309262fringy
glints75714212glints
goings84911522goings
icings9428452icings
kings105825562_kings
klongs11436602klongs
liangs74410592_liangs
lines57054572_lines
ling57447962_ling_
linga66820812_linga
lingas75116562_lingas
lingo66022112_lingo
lingy96925142_lingy
links96430192_links
linns56123332_linns
linos55631502_linos
lins47059052_lin_s
lints57137192_lints
longs65527062_longs
lungs65223882_lungs
lyings10488502lyings
offings14285832offings
olingo736932olingo
olingos846012olingos
palings103915822palings
pilings103313612pilings
pings85830882_pings
plinks124913262plinks
pulings103511322pulings
riflings12227302riflings
rings65029172_rings
rulings83310382rulings
sings65532702_sings
slangs75615342slangs
sling66028802sling_
slinks104315152slinks
stings76220182stings
swings104714452swings
things104914282things
tilings84212792tilings
tings65329192_tings
upflings1433732upflings
wings95727242_wings
wrings104012972wrings
zings154620892_zings

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 Filter178691825510.250714764.0
2DLD Change Limit825511315.82614169.4
3Display Results1311310.0801637.5
 (SQL Overall)1786911316.15629027.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.