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

80 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
pinnula934921pinnula_
pinnulae1044181pinnulae
pinnular1044431pinnular
pinnules1036461pinnules
cannulas1037582cannulas
pinnas85315512pinn__as
pinnulate1145762pinnulate
pinnule936002pinnul_e
annuals7388193_annuals
annular737693_annular
annuls64711733_annul_s
annulus7426613_annulus
cannula937433cannula_
cannulae1046493cannulae
cannular1046283cannular
canulas9312853_canulas
cingula10327173cingula_
cingular11256973cingular
fibulas12228563fi_bulas
fistulas1155403fistulas
indults8289493_indults
ingulfs1134733_ingulfs
insular7138703_insular
insulars8137323_insulars
insults7268963_insults
inulase739413_i_nulase
ligulas8329173li_gulas
linguals9317223linguals
lingula8428803lingula_
lingulae9357033lingulae
lingular9407503lingular
panduras1136953panduras
panfuls1237173panful_s
pendular1144943pendular
peninsulas1252093peninsulas
penults937123p_enults
piacular1246573piacular
piculs103511753pi_cul_s
pignolias1243723pignolias
pignolis1146053pignolis
pignus937953pignu__s
pignuts1035613pignu_ts
pilular938203pi_lular
pilules9510623pi_lules
pinas75434453pi_n__as
pinatas93711503pi_natas
pinballs1246933pinballs
pineals93212853pineal_s
pinfolds1445143pinfolds
pinholes131810663pinholes
pinna75320183pinn__a_
pinnaces12268863pinnaces
pinnacles13276043pinnacles
pinnae84414643pinn__ae
pinnal84814283pinn__al
pinners93518603pinn_ers
pinnies93318443pinn_ies
pinocles1248693pinocles
pinoles93418703pi_noles
pintadas11105083pintadas
pintas85021393pi_n_tas
pintles94118723pi_ntles
pinups1037413pi_nu_ps
pinwales1367963pinwales
planula935773planula_
planulae1044793planulae
planular1044753planular
pneumas1145103p_neumas
primulas1246123primulas
ranulas7311773_ranulas
singular9327563singular
singulars10305633singulars
spinula9257903spi_nula_
spinulae10276963spi_nulae
spinules10249333spi_nules
spirulas10207203spi_rulas
tinfuls1036593tinful_s
vincula1246403vincula_
zinnias1635863zinn_ias
zonulas1637023_zonulas

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 Filter1786911461620.423422437.4
2DLD Change Limit146162806.83021400.0
3Display Results80800.0302666.7
 (SQL Overall)178691807.28324535.4
 
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.