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

92 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
scopula115499(None) 
copula102812041_copula
scapula1136341scapula
scopulae1254611scopulae
scopulas1265481scopulas
copulae112810612_copulae
copular113810602_copular
copulas113811562_copulas
cupula10328432_cupula
scapulae1255432scapulae
scapular1245372scapular
scapulas1246132scapulas
scopulate1366542scopulate
scrofula1363382scrofula
acicula11228133acicula
canula8312963_canula
cedula977643_cedula
coagula1045413_coagula
coala77521123_co_ala
cola66541393_co__la
copal95621783_copal_
copalm125010813_copalm
copals105018943_copals
coppra12306833_coppra
copra98115463_cop_ra
copulate122614113_copulate
could86517713_co_uld
couple104415963_couple
cupola10317693_cupola
cupulae11347853_cupulae
cupular11317623_cupular
cupule103410723_cupule
doula65717773_do_ula
hoopla1147633hoop_la
inocula947263inocula
morula8710473_morula
oscula837293osc__ula
papula103011113_papula
popular11319563_popular
propyla14296633propyla
pula65129373___pula
scapulars1343873scapulars
scapulary1643203scapulary
schul102510413sc_hul_
schuln11256233sc_huln
schuls11299853sc_huls
scilla8310943sc_illa
scofflaw1941433scofflaw
scold85414863sco__ld
scoopful1542963scoopful_
scoopfuls1642203scoopfuls
scop85925523scop___
scope94821483scop__e
scoped115116653scop_ed
scopes104719593scop_es
scoping123513823scoping
scops95820193scop__s
scoria8513503sco_ria
scotia8310803sco_tia
scotoma1155963scotoma
scour75315533sco_u_r
scours84913593sco_urs
scouse84113633sco_use
scout75031453sco_u_t
scouth115011153sco_uth
scouts84817943sco_uts
scowl1012012973sco_wl_
scowls11549593sco_wls
scrofulas1453503scrofulas
scruple1137193scruple
scuba94211593sc__uba
sculk115112463sc__ulk
scull75315763sc__ull
sculp95314843sc__ulp
scuta75815753sc__uta
should1038033sho_uld
sola45541863s_o__la
soul46435713s_o_ul_
souls55127363s_o_uls
spatula935893spatula
specula11187413specula
spicula11259293spicula
spinula9257903spinula
spirula9257703spirula
sporular1065223sporular
sporule937273sporule
sputa74612963s__puta
stipular1045843stipular
stipule936723stipule
stopple1156583stopple
torula6610393_torula
zonula1537223_zonula

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 Filter1786911340270.406440125.6
2DLD Change Limit134027926.95319276.1
3Display Results92920.0462000.0
 (SQL Overall)178691927.40524131.1
 
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.