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

96 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
ossicle94448(None) 
ossicles1054181ossicles
ostiole739012ostiole
popsicle1443652popsicle
possible1245812possible
vesicle12217922vesicle
article9310923article
asshole1046793asshole
assize1538633assi_ze
auricle9139813auricle
bossily1237563bossi_ly
calicle113111433calicle
chicle134312543_chicle
cornicle1258783cornicle
cubicle1337003cubicle
cuticle1138233cuticle
dossil75110903dossi_l_
dossils8669773dossi_ls
ensile62616473ensi_le
fascicle1554633fascicle
fissile10269653fissi_le
follicle1344393follicle
fossick16134733fossic_k
fossicked1942533fossicked
fossicker1843023fossicker
fossicks17134163fossicks
fossil9379353fossi_l_
fossils10379013fossi_ls
funicle12237483funicle
fusible1237023fusible
fusile94313493fusi_le
hospice14117063hospic_e
hostile10312553hosti_le
icicle1036583_icicle
missile92815403missi_le
muscle10310973mus_cle
musicale1247343musicale
obstacle1243593obstacle
office1435693offic_e
omissible1344093omissible
onside7511803onsi_de
oracle84313293o_racle
oriole6814293o_riole
orrice81410163orric_e
oscine8311563osci_ne
oscule838193o_scule
osmic939913osmic__
osmics1036463osmic_s
osmole8128513o_smole
ossia53710403ossi__a
ossicular1144093ossicular
ossific1243103ossific
ossified1276433ossified
ossifier111196273ossifier
ossifies1177563ossifies
ossify1244973ossi_fy
ostioles839273ostioles
panicle11129983panicle
passible1237693passible
pedicle1238973pedicle
popsicles1543663popsicles
possibler1343013possibler
possibly1544483possibly
postiche1547793postiche
radicle103510713radicle
resile64627673resi_le
reticle94112623reticle
risible937923risible
saice75424053_saic_e
sanicle91210263sanicle
seiche11811833_seiche
sessile739523sessi_le
sice65545603__sic_e
sickle124418323__sickle
sidle65124043__sidle
silicle937753silicle
slice74925823_slic_e
smile74823923_smi_le
socle7419573__socle
spicae104313703_spicae
spice95528813_spic_e
spicule11269933_spicule
spile75230083_spi_le
stickle132410973_stickle
stifle93611903_stifle
stile54931573_sti_le
swiple11379233_swiple
testicle1037443testicle
tunicle9308033tunicle
utricle937913utricle
vehicle15175253vehicle
versicle1366583versicle
vesicae12177703vesicae
vesicles13127073vesicles
visible1236923visible
wavicle1534063wavicle

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit134027966.04622167.9
3Display Results96960.0332909.1
 (SQL Overall)178691966.50227482.5
 
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.