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

56 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
infantas1124600(None) 
infanta10237251infanta_
infantes11249631infantes
infants102210771infant_s
incants92012802incant_s
infant92315132infant__
infante101910882infant_e
infantry1443842infantry
infaunas1143862infaunas
andantes9310853andantes
antas55432033___antas
fangas105017193__fangas
fantasm1236593__fantasm
fantast10311703__fantast
fantasy1336153__fantasy
iguanas835373iguan_as
inanes62519803in_an_es
incant82418503incant__
incanted11259543incanted
incents92414533incent_s
indabas1045843inda_bas
indents83114663indent_s
inearths1144933inearths
infalls1038943infa_lls
infamies1346663infamies
infamous1354533infamous
infancies1446973infancies
infancy1546173infan_cy
infantile1245413infantile
infantine1247143infantine
infantries1344683infantries
infarcts1345233infarcts
infares10313023infa_res
infauna1044403infauna_
infaunae1143773infaunae
infaunal1143823infaunal
infects12279713infect_s
infests10279793infest_s
infinites1258693infinites
inflates11512193inflates
infracts1346623infract_s
ingates82716893inga_tes
inlands838783inlan_ds
inmates92715763inma_tes
instants8910153instant_s
intents72115703intent_s
intrants8312863intrant_s
invents102812053invent_s
jnanas13207303jn_an_as
mantas85725363__mantas
marantas10310023marantas
nanas55928633_n_an_as
pinatas93711483pin_a_tas
sinfonias1244313sinfonias
tarantas839193tarantas
unfaiths1443213unfaiths

Search took 9 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 Filter1786911461620.186960704.3
2DLD Change Limit146162568.19017846.4
3Display Results56560.0134307.7
 (SQL Overall)178691568.38921300.6
 
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.