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

91 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
spinulae1027696(None) 
spiculae12218601spiculae
spinula9257901spinula_
spinule9299991spinul_e
spirulae10216571spirulae
pinnulae1044182_pinnulae
spicula11259292spicula_
spicular12238902spicular
spiculate132210162spiculate
spicule11269932spicul_e
spindle103210092spindl_e
spinelle1046222spinelle
spinules10249332spinules
spinulose1142912spinulose
spirula9257702spirula_
spirulas10207202spirulas
aciculae12267703aciculae
apiculate13279883apiculate
cannulae1046493cannulae
canulae9311183_canulae
fibulae12237013_fibulae
inulase739413__inulase
ligulae8308753_ligulae
lingulae9357033_lingulae
lunulae735613_lunulae
papulae11249353_papulae
pilular938203_pilular
pilule8411123_pilul_e
pinnae84414643_pin_nae
pinnula934913_pinnula_
pinnular1044433_pinnular
pinnulate1145763_pinnulate
pinnule936003_pinnul_e
pinole83218783_pinol_e
pintle83818263_pintl_e
pinwale1257843_pinwale
planulae1044793planulae
retinulae945363retinulae
scapulae1255433scapulae
scopulae1254613scopulae
shingle117711283shingl_e
siliculae1154283siliculae
simular938673s_imular
simulate10311133s_imulate
single74520603s_ingl_e
singular9327563s_ingular
sinuate7412163s_inuate
spangle1038403spangl_e
spansule1043623spansul_e
spatula935893spatula_
spatular1044653spatular
spatulas1045473spatulas
spatulate11107173spatulate
specula11187413specula_
specular12217613specular
speculate13239183speculate
spicae104313703spi__cae
spicules12219803spicules
spiculum1464213spiculum
spile75230083spi__l_e
spillage1146263spi_llage
spinage10289653spin_age
spinal84915313spin__al
spinally1338023spinally
spinals93911863spinal_s
spinate93114813spin_ate
spindled12287643spindled
spindler11297983spindler
spindles112710353spindles
spindlier1253873spindlier
spindly13257383spindl_y
spine76534423spin___e
spinel85317333spinel__
spinelike1585353spinelike
spinelles1146083spinelles
spinels94512443spinel_s
spinose937943spin_ose
spittle937923spittl_e
sporular1065223sporular
sporulate1146953sporulate
sporule937273sporul_e
sprinkle1434893sprinkl_e
stimulate1148233stimulate
stipular1045843stipular
stipulate1147323stipulate
stipule936723stipul_e
swindle11389183swindl_e
swingle113510563swingl_e
synurae1044253s_ynurae
veinule1056243veinul_e
zonulae1645963_zonulae

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.1731032896.0
2DLD Change Limit146162917.65319098.7
3Display Results91910.0332757.6
 (SQL Overall)178691917.85922737.1
 
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.