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

51 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
funicular1411476(None) 
funiculars15143261funiculars
auricular1146322auricular
canicular1346472canicular
cuticular1345192cuticular
funiculi1343242funicul_i
funiculus1443472funiculus
furcular1345712fu_rcular
acicular12218673_acicular
articular1179383articular
auricula1045803auricula_
auriculae1145163auriculae
auriculars1255073auriculars
auriculas1146053auriculas
avicular13237283_avicular
avuncular1443323avun_cular
binocular1394613binocular
cubicula1444083cubicula_
curricular14124163curricular
cuticula1244953cuticula_
cuticulae1344263cuticulae
facular122810453f__acular
fascicular1753303fascicular
fibular12267983f__ibular
follicular1552863follicular
funicle12237483funic_l_e
funicles13246833funic_les
furcula1245803fu_rcula_
furculae1345073fu_rculae
lenticular1254393lenticular
lunisolar951563lunisolar
lunular736023lun__ular
manipular1344233manipular
monocular1345813monocular
muscular1246253mu_scular
navicular1444693navicular
orbicular1344693orbicular
ossicular1144093ossicular
pedicular1445773pedicular
radicular1245883radicular
reticular1147113reticular
spicular12238913_spicular
undular837133_un_dular
ungular836783_un_gular
unicolor1043493_unicolor
unifilar1143263_unifilar
unilocular1252393_unilocular
unipolar1043423_unipolar
utricular1145783utricular
vehicular1744283vehicular
vesicular1445473vesicular

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 Filter1786911486410.423422437.4
2DLD Change Limit148641516.71622132.4
3Display Results51510.0163187.5
 (SQL Overall)178691517.15524974.3
 
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.