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

52 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
clavicles164366(None) 
clavicle1543601clavicle_
calicles123811422c_alicles
wavicles1633782_wavicles
calcicoles1344023calcicoles
calices114321693c_alic_es
caliches153812263c_aliches
calicle113111433c_alicle_
calicoes123911583c_alicoes
calvities1438933calvities
calycles15295693c_alycles
canticles1339183canticles
carices114220953c_aric_es
carioles10817063c_arioles
caulicles1344383caulicles
caviares1337993c_aviares
cavies114525003c_avi__es
caviled1348723c_avi_led
caviler1249063c_avi_ler
cavilers1348113c_avi_lers
cavilled1436723c_avilled
caviller1337053c_aviller
cavillers1435603c_avillers
cavils114014393c_avi_l_s
cavities131412613c_avities
cervices1537133cervic_es
ceviches1834843c_eviches
chalices15310813chalic_es
chicles143512503c__hicles
claries93422203clari__es
clarifies1448633clarifies
clarities11312483clarities
claves115020063clav___es
clavicorn1652153clavicorn
clavicular1752793clavicular
clavier1239173clavi__er
claviers1367103clavi_ers
clevises1336903clevi_ses
cliches144213743cl__iches
cornicles1368243cornicles
crevices1536713crevic_es
cubicles1435883c_ubicles
curricles13105423curricles
cuticles1237893c_uticles
flavines1437893flavi_nes
latices9313763_latic_es
lavishes1457403_lavishes
panicles121010103_panicles
plaices11411143pla_ic_es
radicles11249693_radicles
sanicles10149943_sanicles
wavicle1534063_wavicle_

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641528.17018193.5
3Display Results52520.0461130.4
 (SQL Overall)178691528.37221343.9
 
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.