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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
figural114524(None) 
augural856402augural
figurable1543732figurable
figurally1643632figurally
figurant1246722figurant
figurate1237192figurate
figure10258832figur_e
figured12196472figured
figurer11215862figurer
figures11239112figures
fissural1143702fissural
futural1037282futural
anural65714743_anural
aural54428963__aural
binaural1045413binaural
citral81113893ci_tral
crural8610633_crural
digital937063digital
diurnal844883di_urnal
dural64923893__dural
epidural1143723epidural
faucal11339963f_aucal
faunal94711593f_aunal
federal1148533federal
femoral1238723femoral
feral85424653f__eral
feudal1037683f_eudal
fibril1137163fi_bril
fibula11258053fibula_
fibulae12237013fibulae
fibular12267973fibular
fibulas12228563fibulas
fiducial1443263fiducial
figurants1343973figurants
figuredly1742313figuredly
figurers12254873figurers
figurine1245603figurine
figuring1336283figuring
filarial1147863filarial
filial93013253fi_lial
fimbrial1544193fimbrial
final83922033fi__nal
finial92814183fi_nial
finical1239693finical
fiscal1139333fi_scal
fixure16256543fixur_e
fixures17596063fixures
flexural1842443flexural
floral94313813f_loral
frugal1036393f_rugal
fugal95613033f__ugal
funeral1037623funeral
furan84320013f__uran
furfural1473473furfural
furl77030883f__ur_l
goral65125753__goral
gyral94412783__gyral
jural125120483__jural
liberal9310193liberal
ligula7359673ligula_
ligulae8308753ligulae
ligular8348533ligular
ligulas8329173ligulas
ligure7279473ligur_e
ligures8269893ligures
lingual8379083lingu_al
literal7613273literal
litoral7610763litoral
mineral9312733mineral
mistral91013643mistral
mitral81314323mi_tral
mural75225113__mural
natural739513natural
neural6311993_neural
pleural956673pleural
plural839823_plural
ritual6310623ritu_al
rural55821173__rural
signal73711483sig_nal
sural55931263__sural
sutural7310223sutural
timbral11237193timbral
ungual738183ungu_al
viral86419593vi__ral
visual938803visu_al
ziggurat1952393ziggurat
zikurat2044683zikurat

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.423422437.4
2DLD Change Limit134027876.65620136.3
3Display Results87870.0302900.0
 (SQL Overall)178691877.10925135.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.