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 “costive” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

271 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
costive1231284(None) 
captive1438972captive
coactive1598622coactive
codrive1337652codrive
conative131214622conative
connive1238992connive
contrive13311352contrive
cootie84223092cooti_e
cosie74728272cos_i_e
cosine83823512cos_ine
costae85319682cost_ae
costate94019272costate
costing104323022costing
costively1746352costively
costume1157852costume
cystine1239332cystine
festive1339772festive
hostile10312552hostile
motive113112142mo_tive
positive1349992positive
postdive1445762postdive
postie84123962posti_e
restive10315932restive
votive12348932vo_tive
abortive1346883abortive
active11313743_active
adoptive1445503adoptive
amative12311733amative
bastile9313913bastile
bootie85421163booti_e
captives1538623captives
cassine93817283cassine
caste75932363cast__e
casting104628343casting
castle84918963cast_le
cattie85221023catti_e
causative1445833causative
centile94217183centile
centime114513033centime
cesti75217423cesti__
cestode1037963cestode
chastise1348173chastise
chive135117623c__hive
chowtime1842953chowtime
coasting113615513coasting
coastline1196363coastline
coastwise1463023coastwise
coatee84327223coat_ee
coati75624643coati__
coating103525313coating
coatis85122603coati_s
cocaine111315173cocaine
codeine103815033codeine
coderive1447693coderive
codriven1444393codriven
codriver1435913codriver
codrives1437663codrives
codrove1336423codrove
coercive1545873coercive
coesite9713623coesite
cognise1059683cognise
cognitive1545483cognitive
cognize1957683cognize
cohesive1646073cohesive
coition9314313coition
collide103214793collide
collie83621993colli_e
coltish121310933coltish
combative1847213combative
combine133014723combine
combustive1953753combustive
commie124215523commi_e
commove1635963commove
compile13312443compile
comte96125473comt__e
concave1439373concave
conceive1539233conceive
concise11314473concise
confide13310203confide
confine12315583confine
congestive1647613congestive
coniine9316803coniine
conine84528553co_nine
connived1436433connived
conniver1337493conniver
connives1339723connives
conserve1339933conserve
conspire1257873conspire
constative15410103constative
construe1049053construe
consultive1546673consultive
conte76633203cont__e
continue10311123continue
contrite10318543contrite
contrived1547993contrived
contriver1448343contriver
contrives14311703contrives
contuse9311413contuse
contusive1445783contusive
cookie123716043cooki_e
cookstove1842873cookstove
coolie83821603cooli_e
coontie9311423coonti_e
cooties93725733cooties
coppice1537483coppice
corbie103618203corbi_e
cordite10315263cordite
cornice11612933cornice
corrie83621233corri_e
cortege1098953cortege
cortices12615023cortices
cortin82423153corti_n
cortina91915973cortina
cortins92421333cortins
corvine122113643corvine
coshing134316433coshing
cosied94819893cos_ied
cosier84423763cos_ier
cosies84932163cos_ies
cosign958783cos_ign
cosily113613853cos_ily
cosines94122673cos_ines
cosmic12410343cosmi_c
cosmid11810643cosmi_d
cosmids1237633cosmids
cosmism1337013cosmism
cosmist11311333cosmist
cost68057943cost___
costa75523733cost__a
costal85419513cost_al
costar85518613cost_ar
costard104113353costard
costars94218013costars
costed95623123cost_ed
coster84331293cost_er
costers94128343costers
costlier1038523costlier
costly114012333cost_ly
costrel9310373costrel
costs77231143cost__s
costumed1365033costumed
costumer1275103costumer
costumes1258013costumes
costumey1563523costumey
cosying134513133cosying
cote66648733co_t__e
coting94629253co_ting
cottae84615703co_ttae
cottage104210573cottage
cottier93814173cottier
cotype1346823co_type
couthie121810553couthie
couture9310623couture
cove95837073co___ve
cowhide1636143cowhide
cowpie133511513cowpi_e
cowrie113814283cowri_e
cowrite123612683cowrite
cozie163519133co_zi_e
creative132812803creative
crescive1545283crescive
crosstie1046943crossti_e
crostini1038293crostini
crostino1038883crostino
curative13310403curative
cursive1237833cursive
cutie76925933c_uti_e
cysteine1345333cysteine
cystic132710653cysti_c
cystines1339473cystines
dative10311813_dative
decoctive1745863decoctive
destine83719953destine
donative12139873donative
egestive1246833egestive
elative10312453elative
emotive1239193emotive
eosine64519413eos_ine
erosive1039203eros_ive
fictive1537023fictive
footie94718143footi_e
forgive1436193forgive
furtive1337173furtive
hogtie102711773hogti_e
hospice14117063hospice
hostage113111233hostage
hostiles11312213hostiles
hosting114318383hosting
hottie92514383hotti_e
jostle13319863jost_le
jussive1734293jussive
justice1637423justice
locative1338683locative
massive12289773massive
misgive13339033misgive
mislive122812693mislive
missive122413143missive
mistime11312613mistime
monitive1349993monitive
mortice11711493mortice
mortise9713533mortise
moste75925083most__e
motile83818343mo_tile
motived13357763mo_tived
motives123611893mo_tives
native9613013_native
nosedive1243993nosedive
notice8313443no_tice
octave11157343_octave
ogive9379093_o_give
olive84817153_o_live
optime1079353_optime
oscine8311563_oscine
ostia52315583_osti_a
ostiole739013_ostiole
ostium8310133_ostium
outgive11199253_outgive
outlive102513033_outlive
outvie92412803_outvie
passive12239593passive
pastie85525523pasti_e
pastime114611973pastime
plosive1236673plos_ive
poetise9314043poetise
poetize18310773poetize
pontine92419053pontine
positiver1445483positiver
positives1459173positives
postage103214853postage
postfire1346273postfire
postiche1547793postiche
posties93128813posties
postin83521033posti_n
posting105622243posting
postins93721203postins
postique1945873postique
posture9313253posture
potsie83916033potsi_e
poutine93316823poutine
prostie91617743prosti_e
restrive11310923restrive
rotative11310343rotative
routine72615903routine
scottie937463scotti_e
sestine73017923sestine
shive114423423__shive
skive124614113__skive
softie93312483softi_e
solstice1047223solstice
sorptive1346473sorptive
sortie63621993sorti_e
sportive1348333sportive
stative102612933stative
stave85324993__stave
stile54931573__stile
stime76521803__stime
stipe76523373__stipe
stiver93915733__stiver
stove85220253__stove
strive95020963__strive
swive115316193__swive
tontine72316143tontine
tortile7313193tortile
tussive1035303tussive
unitive10310563unitive
vestige1137433vestige
visive1257873vis_ive
vocative1637913vocative
volitive1446893volitive
vomitive1645853vomitive
votives13337953vo_tives

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 Limit1340272717.06318975.9
3Display Results2712710.0932914.0
 (SQL Overall)1786912717.56223630.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.