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

102 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
flexion173507(None) 
flexions1844411flexions
fluxion1735041fluxion
alexin132311482alexi_n
deflexion2042822deflexion
flection13239562flection
fleuron1055572fleuron
flexagon1942062flexagon
flexile1735072flexile
flexing18358992flexing
flexional1942472flexional
flexor1634502flex_or
fluxions1844422fluxions
inflexion1943182inflexion
legion75712982_legion
lesion64715062_lesion
lexicon1643902_lexicon
reflexion1943612reflexion
alation72920553alation
alencon945733alencon
aleuron757383aleuron
alevin92511513alevi_n
alexia132910463alexi_a
alexias14249793alexias
alexine142410543alexine
alexins141910663alexins
axion1211316913__axion
clarion9311663clarion
claxon1536583clax_on
deflexions2142563deflexions
deletion92011973deletion
effluxion2251853effluxion
elation73620453elation
election102015353election
elevon977953ele_von
elision72311103elision
elusion72310953elusion
elution72913823elution
exon117116803__ex_on
faction122613333faction
falchion1644343falchion
fanion94514323f_anion
fashion1337843fashion
feign94210713f_e_ign
felon84619293f_e_lon
fermion1236763fermion
fiction122010733fiction
fission1038733fission
flacon1138633fl_acon
flagon1037983fl_agon
flatiron1144623flatiron
flavin1239303flavi_n
flaxen16518573flax_en
flaxier17337983flaxier
flections14239213flections
fleeing113511293fleeing
flehmen1534913flehmen
flemish1536373flemish
fleurons1155343fleurons
flex146123473flex___
flexagons2041673flexagons
flexed17419093flex_ed
flexes164512953flex_es
flexible2043143flexible
flexibly2342733flexibly
flexors1734773flexors
flextime2042813flextime
flexuose1841863flexuose
flexuous1842413flexuous
flexure1743413flexure
fleying14329873fleying
florin9312653flori_n
fluxing18398923fluxing
fluxional1952403fluxional
fusion939773f_usion
hellion10311143hellion
inflexions2042893inflexions
klaxon1733853klax_on
lection92614863_lection
legions84611783_legions
lemon75618183_le_mon
lepton82510803_lepton
lesions73813873_lesions
lesson64412043_lesson
leukon1036143_leukon
levin84816413_levi_n
lexica1536103_lexica
lexicons1743893_lexicons
lexis125916033_lexi_s
lion46334453_l__ion
logion76013723_logion
lotion65716523_lotion
olefin937583olefi_n
olein5316003ole_i_n
pleon74216383ple__on
pleuron976343pleuron
plexor1535253plex_or
plosion939113plosion
reflexions2043303reflexions
region74614903_region
sexton133610793_sexton
ulexite1445723ulexite

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271027.17318684.9
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.60923484.2
 
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.