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

99 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
crinoids114736(None) 
cricoids1347181cricoids
crinoid1039941crinoid_
actinoids1246302actinoids
carcinoids1584452carcinoids
conoids10813882c_onoids
cricoid1239242cricoid_
crinoidal1254422crinoidal
cyprinoids1852512cyprinoids
echinoids1544222echinoids
quinoids1845692quinoids
actinoid1148013actinoid_
adenoids1056863adenoids
araneids947743araneids
aroids75118223ar__oids
brinies93317913brin_ies
brionies10310543brionies
candids113812693c_andids
canids95118133c_an_ids
carangids1344573carangids
carcinoid1465663carcinoid_
cardioids1345223cardioids
carotinoids1452583carotinoids
catenoids1246433catenoids
ceboids1237653c_eboids
cestoids11308273cestoids
cheloids1438033cheloids
chinones13510473chinones
chinooks1774783chinooks
chinos115018693chino__s
chorioids1545683chori_oids
choroids1438693choroids
cirsoid1038123cirsoid_
cissoids1145363cissoids
clinics11338743clin_ics
coccoids12176793coccoids
coincide1346493coincide
coincides1446433coincides
colloids11310173colloids
conoid9818883c_onoid_
coracoids1445833coracoids
coronoid1148943coronoid_
corticoids1544183corticoids
crannies10313013crannies
cretinoid1244363cretinoid_
cricetids1443893cricetids
cringed113312403cringed_
cringers112511873cringers
cringes103215503crin_ges
cringing123311383cringing
cringles11329463cringles
crinite9513633crin_ite
crinites10612763crinites
crinkles14269163crinkles
crinoline1147773crinoline
crinolines1246733crinolines
crinums1135863crin_ums
crisis83716343cri_si_s
critics112811093cri_tics
cronies9622503cron_ies
crowds124910763cr__owds
crunode1034713cruno_de
crunodes1144973crunodes
cryonics1555413cryonics
ctenoid1078683ctenoid_
cuboids1236723c_uboids
cyanids13297933cyan_ids
cycloids1647043cycloids
cyprinids1742643cyprin_ids
cyprinoid1753463cyprinoid_
cystoids14306733cystoids
droids84712583dr__oids
echinoid1445993echinoid_
ericoid1049893ericoid_
fibrinoids1652443fibrinoids
ganoids939333_ganoids
grinds84511843grin__ds
hominoids1544693hominoids
lipoids1038233_lipoids
opioids1036523opi_oids
paranoids1248913paranoids
prismoids1443613prismoids
pyrenoids1544803pyrenoids
quinoid1737353quinoid_
ranids75118703_ran_ids
resinoids1044703resinoids
retinoids1045383retinoids
rhizoids2143463rhizoids
rinds64826143_rin__ds
schizoids2443383schizoids
scincoids1453413scincoids
tineids8337873_tineids
trendoids1143943trendoids
triacids1146723triacids
trioxids1644443trioxids
triploids1245893triploids
tripods10359053tripo_ds
urinous7310083urino_us
viroids1137923_viroids

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.1561145455.1
2DLD Change Limit146162996.92021121.7
3Display Results99990.0333000.0
 (SQL Overall)178691997.10925135.9
 
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.