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

61 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
planulae104479(None) 
planula935771planula_
planular1044761planular
planulate1146911planulate
canulae9311192_canulae
lunulae735612_lunulae
papulae11249362p_apulae
pinnulae1044182pinnulae
alulae6312743__alulae
blastulae1143063blastulae
cannulae1046503cannulae
canula8312973_canula_
canular9310333_canular
canulas9312863_canulas
canulate10314553_canulate
faculae123210353_faculae
glandular1142793glandular
glandule1043853glandul_e
granular946903granular
granulate1059183granulate
granule839473granul_e
lacunae9116803_lacunae
laurae64011663_la_urae
ligulae8308753_ligulae
lingulae9357033_lingulae
lunula636173_lunula_
lunular736023_lunular
lunulate838253_lunulate
lunule638433_lunul_e
maculae113412863_maculae
pabular11259483p_abular
papula103011123p_apula_
papular11299773p_apular
papule102212133p_apul_e
piacular1246583piacular
pinnula934923pinnula_
pinnular1044433pinnular
pinnulate1145763pinnulate
pinnule936003pinnul_e
plague93610853plagu__e
planar84212713plan__ar
planate9314573plan_ate
planche14299763plan_che
plane74929143plan___e
planeload1243733planeload
plantar9369993plan_tar
plantlet10310013plantlet
plantlike1544943plantlike
planuloid1243483planuloid
plaque17317643plaqu__e
pleurae945863pl_eurae
plumular1243303plumular
plumule1134303plumul_e
radulae837963_radulae
ranula6311813_ranula_
ranular739443_ranular
ranulas7311783_ranulas
scapulae1255443scapulae
spinulae10276963spinulae
valvulae1442723valvulae
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.410435831.7
2DLD Change Limit146162617.09320606.5
3Display Results61610.0134692.3
 (SQL Overall)178691617.51623774.7
 
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.